Module sqlite_schema 

SQLite Schema Virtual Table

Implements sqlite_master (and its alias sqlite_schema) for SQLite compatibility. These virtual tables return metadata about database objects in the standard SQLite format.

Schema:

CREATE TABLE sqlite_master (
  type TEXT,      -- 'table', 'index', 'view', 'trigger'
  name TEXT,      -- name of the object
  tbl_name TEXT,  -- table the object is associated with
  rootpage INT,   -- internal (always 0 for VibeSQL)
  sql TEXT        -- CREATE statement that created the object
);

Reference: https://www.sqlite.org/schematab.html

Functions

execute_sqlite_schema_query

Execute a sqlite_master/sqlite_schema query

get_sqlite_schema_table_schema

Get the schema for sqlite_master/sqlite_schema

is_sqlite_schema_table

Check if a table reference is sqlite_master or sqlite_schema