FireSQL

FireSQL is a JavaScript library (v2.0.2, latest stable) that enables querying Cloud Firestore using SQL syntax. Built on the official Firebase SDK, it translates SQL SELECT statements into Firestore queries, minimizing server requests. Key differentiators: support for SELECT, WHERE, ORDER BY, LIMIT, GROUP BY, aggregate functions (AVG, MIN, MAX, SUM), nested field access with backtick syntax, and realtime updates via RxJS observables (requires rxfire). Limitations include no INSERT/UPDATE/DELETE, no JOINs, limited LIKE, and no COUNT. Releases are infrequent; maintained on GitHub.