List the names of all tables and views in a SQLite database file. path must be an absolute filesystem path to the .db/.sqlite file.

Describe the schema of a single table or view: its columns, declared types, a boolean not-null flag (true when the column is NOT NULL), default values and a boolean primary-key flag (true when the column is part of the primary key). path must be an absolute path; table is the table or view name.

Run a single read-only SQL statement against a SQLite database file and return the rows as TSV (a tab-separated header row of column names, then one line per row). The database is opened read-only, so INSERT/UPDATE/DELETE and schema changes will fail. Exercise caution: results are NOT truncated, so a broad query like SELECT * FROM big_table can return an enormous result set — add a LIMIT and select only the columns you need. path must be an absolute filesystem path; sql must be a single statement.