SQLite Forum

For a given SQL query, mechanisms for figuring out which physical columns would be returned?
> I think this might work!

Ok, great. Just one remark I should have made before: The output format of `EXPLAIN` is not stable, it may change over versions.

Also, it lists the "byte code" for the virtual machine that executes the query, so if the optimizer get smarter, the code may change.

It might be stable enough for your purpose though.