Custom SQL Editor

Users can type an SQL query in the Custom SQL Editor if you enable custom SQL queries. This editor is invoked from the Data Source Wizard.

The Custom SQL Editor highlights the SQL syntax to help users write and read queries.

web-designer-custom-sql-editor

The query validation mechanism only allows custom queries that contain SELECT statements (except for SELECT INTO clauses). You can also implement custom validation.

IMPORTANT

Custom SQL queries in your web applications expose your databases to possible SQL injections. Make sure you use secure SQL validation to prevent the execution of harmful requests before you enable this option. See General Security Considerations for more information.

See Also