Query Optimisation of Semantically Equivalent Queries in SQLite3

Empirical investigation of SQLite's query optimiser behaviour across semantically equivalent query pairs, examining subquery flattening, co-routines, index utilisation, and execution plan selection.