Google Sheets query

Hi, some days ago I successfully deployed a self hosted container since I’m looking for a Google Sheets alternative. I’m digging into all the features and reading the docs and I have to say I’m amazed by the endless possibilities Grist provides.
Anyway I’m stuck trying to make a specific doc work like on Google.
That document is structured with a main sheet containing all my records without calculations, just like a db, and then a pletora of other sheets where I query the main sheet (the only sheet where I add new records) and do aggregations and statistics.
Since Sheets’ query language is quite standard, I was surprised to learn that I can’t use it in Grist (or at least I haven’t found out how yet).
I tried digging into widgets but it’s an entirely different workflow and I really don’t want to rethink all my queries if possible.
I know this is quite generic without a live sample, but can someone please point me in the right direction?