The following code creates views showing engine-related metadata, including SQLite version, Source ID, function list, collation list, compile options, module list, and pragma list. The included SELECT statements retrieve this information directly if executed from a console or a GUI DBA tool.

CREATE VIEW service_meta_sqlite_version AS
SELECT sqlite_version() AS version;

CREATE VIEW service_meta_sqlite_version_ex AS
SELECT sqlite_version() AS version, sqlite_source_id() AS source_id;

CREATE VIEW service_list_functions AS
SELECT * FROM pragma_function_list() AS functions ORDER BY name, nargs;

CREATE VIEW service_list_collations AS
SELECT * FROM pragma_collation_list() AS collations;

CREATE VIEW service_list_compile_options AS
SELECT * FROM pragma_compile_options() AS compile_options;

CREATE VIEW service_list_modules AS
SELECT * FROM pragma_module_list() AS modules ORDER BY name;

CREATE VIEW service_list_pragmas AS
SELECT * FROM pragma_pragma_list() AS pargmas ORDER BY name;