Support for functions/procedures

[orellabac]

I think it will be great to have the option to show functions and procedures.

I tried for example to extend a driver using a query like this:

const fetchFunctions: IBaseQueries['fetchFunctions'] = queryFactory`
SELECT
  '${ContextValue.FUNCTION}' as type,
  FUNCTION_NAME AS name,
  FUNCTION_NAME AS label,
  FUNCTION_NAME || '(' || ARGUMENT_SIGNATURE || ')' AS detail,
  FUNCTION_SCHEMA AS schema,
  CURRENT_DATABASE() AS database,
  ARGUMENT_SIGNATURE AS signature,
  DATA_TYPE AS "resultType",
  NULL AS args,
  NULL AS "argsNames",
  FUNCTION_DEFINITION AS source,
  'function' as "iconName",
  '${ContextValue.NO_CHILD}' as "childType"
FROM
    INFORMATION_SCHEMA.FUNCTIONS
WHERE
  FUNCTION_SCHEMA = '${p => p.schema}'
ORDER BY name
;`;

It seems to get some date but shows nothing so probably I am doing something wrong.

But there is not support at all for stored procedures.

Is it possible to do that ?

[michaellifly]

any update?

[orellabac]

Not yet. It seems to be something in the SQLTools extensions. They have some condition that validates the file language to be .sql and the language is changed to snowscriptjs for syntax coloring. So I think the issue requires a fix on the SQLTools side but I am still looking into it to see if there is any workaround I can do.

[jankap]

Would love to see stored procedures supported too. Any way we can help with that?

[bombillazo]

I second this, for PostgreSQL as well! Being able to at least view the source and update of a function is an important feature in a DB Client.