I have a few doubts about ODBC scalar function support.
After having installed the driver and created a DSN, is there some flag that can be set to disable support for scalar functions like {fn current_date()}, and in a way that clients can detect by calling SQLGetInfo?
Alternatively, is there a way to configure a DSN so that scalar functions are sent to the database "as themselves", for example {fn current_date()} =====> current_date() ?
Looking in the driver source code, I see a file odbc.sql, that contains Postgres function definitions. What is the purpose of this file? To be able to invoke scalar functions directly without needing the {fn ...} syntax ?