How to return count(*) for pagination?
Check out this answer, it helped me to find the solution
https://discord.com/channels/1043890932593987624/1164627420368875529/1164662014237487299
https://discord.com/channels/1043890932593987624/1164627420368875529/1164662014237487299