Bigquery DDL for procedures returns "-- Source code not available"

### Description

Hi,

After connecting to BigQuery, when either:
* Looking at the properties of a procedure, or
* right clicking the procedure > Generate SQL > DDL
Both cases result in the code "-- Source code not available", and nothing else.

My account has the rights to see and create the DDL of procedures. To recover the procedure DDL, this simple query works (and can be executed by dBeaver:
```sql
select ddl
from `project-name_here`.SCHEMA_NAME_HERE.INFORMATION_SCHEMA.ROUTINES
WHERE routine_type = 'PROCEDURE'
and routine_name = 'PROCEDURE_NAME_HERE'
;
```

There does not seem to be anything relevant in the Error logs that I can see.

Would it be possible to implement recovering the DDL for procedures correctly? For tables it already works.

Happy to help debugging if necessary

Thanks!

### DBeaver Version

24.1.2.202407071610

### Operating System

Windows 10

### Database and driver

BigQuery, driver: google_bigquery_jdbc_simba, SimbaJDBCDriverforGoogleBigQuery42_1.5.0.1001.zip

### Steps to reproduce

1. Connect to BigQuery. I'm using User Oauth successfully
2. Right-click a procedure ( project > schema > procedures > procedure_name ) >> Generate SQL > DDL
3. The result is "-- Source code not available"
4. It should be the DDL of the procedure. See main text of the bug report on how to recover the procedure DDL via SQL.

### Additional context

_No response_