Yes, and there's tricks where you can add speculative future data, which won't actually be stored in the DB. No doubt helps with projections.

Also I like the idea that queries can invoke your own code. (Which is feasible since the queries execute on the same machine as your app.)