Table filtering, sorting, pagination.

[jeneizs-74]

First of all, I would like to express my appreciation for your work!
I value not only the work and quality but also the goal and the idea that a website can be built using only SQL commands.

I am a beginner in SQLPage, but I love SQL, especially PostgreSQL.

I have a question, and if it’s not already addressed, then it’s more of a suggestion.

I would like to implement similar capabilities to those I’ve already solved in my native application, but I would need some information here to do so.

For example:
In the case of a table, I believe pagination, filtering, and sorting would make sense if these could be "pushed" to the database side.
They could translate into "WHERE", "ORDER BY", "LIMIT", and "OFFSET". I know some of these are already achievable, but I think pagination only makes sense if I can paginate the already filtered data. And if I navigate further, I should still be able to do so within the filtered data. The same applies to sorting.

I think it would be possible to construct the corresponding SQL for these actions, which could be sent to the database. However, for this, I would need, for instance, to know which cell is active. If I know that, I should be able to get information about it, like which field it displays or its position in the query. For instance, in SQL, I can do this:
SELECT col1, col2 FROM table1 ORDER BY 2;

What’s your opinion?