I’m migrating away from Google Sheets, so far with a lot of success, but I miss certain functions that at not included in the latest version of Calc. e.g =QUERY.
Query is a powerful function that I am finding it impossible to replicate with other functions that come with Calc
You would need the help of Base for this. It is possible to have a spreadsheet as datasource of an odb. Then you can query this datasource and drag the queries in other spreadsheets.
.
Not so powerful as using a true database, but if someone want’s to do it this way…
Thanks 
looks like It’s been there for a while. Hope someone picks it up and adds it soon so I can leave Google Sheets.