[thestepafter]

Even better, use stored procedures / routines on top of views and only query the stored procedures from the frontend.

[maxbond]

I like it, but the only benefit we've retained at that point is eliminating round trips. Which is pretty significant. But we're still engaging in API design, we're just doing it in Sqlite.