This EsqlQuery only uses the standard JDBC API approaches.
Please note that whether this is good, ok or bad depends
on the driver implementation of your database vendor.
It should work with all JDBC compliant databases.
Unfortunately it seems NOT to work with mssql

getRowCount

AFAIK this is the proposed JDBC API way to get the number
of results. Unfortunately -at least some- driver implementation
are transfering the complete resultset when moving to the end.
Which is totally stupid for limit/paging purposes. So we probably
better stick with an additional count query from the AbstractEsqlQuery