Why is SQLite unable to perform a WHERE and an ORDER BY clause simultaneously in a VIEW?
Context I’m trying to replicate the the INFORMATION_SCHEMA views from MySQL in SQLite (I have tools that expect these views). For the INFORMATION_SCHEMA.COLUMNS view, I have the following query WITH RECURSIVE table_list AS ( SELECT name, schema FROM pragma_table_list() UNION SELECT name, ‘main’ FROM pragma_module_list() WHERE name NOT LIKE ‘fts%’ AND name NOT LIKE ‘rtree%’ […]