Include the total number of results in the response of paginated queries.

Similar to https://feedback.xata.io/feature-requests/p/include-total-hits-in-search-response

From Discord: https://discord.com/channels/996791218879086662/996791219348852836/1152677810842914887