include last result when paginating queries because the same object can be returned multiple times if related rows are included.
make tree fields in queries into scalar subqueries
just use LIMIT OFFSET for pagination, sigh
field formating and headers for query results
better handling of fetching status for result scrolling