I can’t remember if this is the exact library LightSpeed uses, but this CG/SQL library that Meta made makes it easier to write complex SQL queries for SQLite:

I can’t remember if this is the exact library LightSpeed uses, but this CG/SQL library that Meta made makes it easier to write complex SQL queries for SQLite: https://cgsql.dev/ https://cgsql.dev/