11.4 Custom SQL Handler

11.4.1 Registering SQL Handler

11.4.2 Returning a Custom Result

11.4.3 Result Data Specification

The shell global object is extended with register_Sql_Handler, a function which enables you to register a custom SQL handler. This handler can execute pre-processing steps for the given SQL statements and extend the supported SQL statements with non-standard SQL.

The SQL handler detects SQL statements executed in one of the following ways:

• Using the \sql command

• SQL mode.

• The runSQL function in session objects.

• Using the --execute/-e command line option.

• Using the --file/-f command line option.