SQLite Forum

Feature request: add index info to WITH clause table
Login
YES, I like your proposal to take the CTE table declaration similar to a "CREATE TABLE" statement to include the index declarations.