I doubt sqlite will catch up soon in terms of analytics due to a few below reasons. The SQL dialect is so much lacking that it seems intentional. They are mean

I doubt sqlite will catch up soon in terms of analytics due to a few below reasons. The SQL dialect is so much lacking that it seems intentional. They are meant to be a transactional database, not an analytics one. Sqlite also takes pride on stability (deployed on a billion android devices). Adding 100+ analytics capabilities e.g. functions is not gonna be easy in terms of maintaining stability. I want to be wrong though because my paid app (superintendent.app) uses Sqlite. Not supporting analytics well is the number one complaint.