[amolo]

limited querying capabilities though.

[fulafel]

Yep. There are some clunky escape hatches (you can use simple SQL in QUERY() or script in JS etc) in Google Sheets at least. But you should use or migrate to something else if you know you're going to need them.