Use the new SQL window to build and execute SQL queries and statements. The SQL window is essentially a script editor wherein you can write and execute one or more SQL statements along with pre and post script processing snippets. The scripts are run using the immediate mode interpreted MapBasic and are not compiled.
For details about the SQL window, please see Using SQL Window.