SQLite_Connection.query

queryqueryalias

Group: Input

Documentation

Set up a query returning a Table object, which can be used to work with data within the database or load it into memory.

Arguments

• query: name of the table or sql statement to query. If supplied as Text it is treated as a table name.
• alias: optionally specify a friendly alias for the query.

Errors

• If provided with a Raw_SQL query or Text that looks like a query, if any SQL error occurs when executing the query, a SQL_Error error is raised.
• If provided with a Table_Name or a text short-hand and the table is not found, a Table_Not_Found error is raised.