yep, we do the same but using duckdb, it's got a lot more analytical functions and closer to hive than sqlite