Hi team,
In such menu you want to build a more complex select using native SQL functions but also, why not, functions created on the database. So it would be interesting to show available functions, well in my case the target is oracle 
I think they also exist in sql server for example. It would greatly help end users to build expressions.
Thanks for the idea!
I can see one possible problem in implementing this - there is no single SQL language and thus no single list of valid functions. The functions available can vary quite significantly between different database engines. There is also some variation between the syntax of functions that are named the same.
We could of course only support the most common DB engines, such as the 9 supported natively within EasyMorph. But new functions are added over time and so which are valid for the specific engine would be dependent on the DB version we are connecting to. The likely combinations would be huge.
For those databases supported through ODBC, the problem would be even bigger. Wikipedia’s “relational database” list contains more than 100 and I can think of a couple I’ve come across over the years which aren’t on the list. Add to this the non-relational databases such as Mongo and DynamoDB.
With all that said, the EasyMorph product and development teams continue to surprise me with clever solutions to big problems, so you never know….
Hi Romain,
Are you talking about built-in SQL functions or about stored functions and procedures, created in a specific DB by its admins and users?
Stored functions. We can see stored tables, views but not stored functions.
I thought you meant built-in functions 
Sorry I was unclear. Like I deploy table SCHEMA.TABLE, I deploy view SCHEMA.VIEW and I deploy function SCHEMA.FUNCTION(…). I’d like to see them all in the query editor in order to use them. Functions would be used in the expression editor, Tables and views, well it remains the same.