One of the major omissions is that there is no "GROUP BY" equivalent. For example I wanted to generate a table with average book rating grouped by author, but it wasn't possible.
Why not just use Access (I suppose LibreOffice has an equivalent too)? It probably would be more work to set up, but you would have a proper database with the ability to use SQL for queries.
