Feature Request for OVER clause [Window function ?]

[k03rdt6]

Hello mate
Is there a possibilty of OVER cluse support in Lib may be it already exist and I overlooked.
I was trying to achive my pagination logic and needed to use OVER cluase with limit.
my sql logic may be off in this regard but I was trying to achive something like this

select id,firstName,lastName,count(id) OVER() from user_profile order by id limit 50;

it just saves me trouble of writing seperate query for just a count when i add multiple conditions
I am pretty sure this could be achived by left join or somthin similar or I could be shootin blind here

cheers.

[fnc12]

Hello. This is a good feature request cause WINDOW functions are very powerful but noone before requested it. Could you provide a query you desire to execute please? It will help me very much

[k03rdt6]

Thanks for quick reply
This is from test code if you want detailed one i can post that too but it would be bloated for this instance don't you think ?

select id,firstName,lastName,count(id) OVER() from user_profile where id >(:refId) and order by id limit (resultperpage);
Just a hunch it would not be possible to implement this feature in get_all because of class bindings and all