SQLServer_Connection.execute_query

execute_queryquerylimitwrite_operation

Aliases: sql

Documentation

Executes a raw query returning a Table object, which can be used to get the results of the query. This is meant for advanced users who need to call direct SQL queries that are not supported by the query method.

Arguments

• query: either raw SQL code as Text or an instance of SQL_Statement representing the query to execute.
• write_operation: if set to True, the query is expected to be a write operation and will only run if the output context is enabled. If set to False, the query is expected to be a read operation and will run regardless of the output context. Defaults to True.