Creates an empty SQLite database and returns it as a binary object. This can be used to initialize an empty SQLite database in a PostgreSQL column.
Executes a SQL query on a SQLite database stored as a binary object and returns the result as a table of JSON-encoded rows. This function is useful for querying SQLite databases stored in PostgreSQL columns.
Executes a SQL statement (such as INSERT, UPDATE, or DELETE) on a SQLite database stored as a binary object. The updated SQLite database is returned as a binary object, allowing further operations on it.
Extracts a text value from a specific column in a row returned by query_sqlite. Use this function to retrieve text values from query results.
Extracts an integer value from a specific column in a row returned by query_sqlite. Use this function to retrieve integer values from query results.