Custom Database Query

Mizső — Tue, 20 Aug 2024 10:47:44 GMT

Is there any plan to upgrade the custom DB query to extension 2.0 framework?

Thanks in advance for your replay.

Best regards,

Mizső

Re: Custom DB query

jegron — Tue, 21 Mar 2023 11:32:11 GMT

Hello @Mizső ,

I am looking for too. I have several stored procedure to run with Framework 2.0.

For your information, you can run custom Extension 2.0 for MSSQL and Oracle :

This limits applies :

Only SELECT queries are available
- MySQL queries can also begin with SHOW GLOBAL STATUS
Only one query can be executed at a time
Queries containing comments are rejected
To prevent data integrity violations (manipulating, changing, or deleting data), the SQL data source executes the queries in rolled-back transactions. For this reason, databases that don't support transactions are not supported as a SQL data source.

Also there is already this following datasources in the schema :

"sqlOracle": {

"sqlServer": {

"sqlPostgres": {

"$ref": "sql.schema.json"

"sqlMySql": {

"$ref": "sql.schema.json"

"sqlSnowflake": {

"$ref": "sql.schema.json"

"sqlHana": {

"$ref": "sql.schema.json"

"sqlDb2": {

"$ref": "sql.schema.json"

Mizső — Tue, 21 Mar 2023 12:27:22 GMT

Thanks very much for share this information. We are going to test the Oracle extension.

Best regards,

János