Q: How to return total count of records in a FastAPI paginated API response?

A: Run two queries: one for paginated items and one for the total record count using COUNT(*). Example JSON response:
{
“total”: 250,
“page”: 2,
“limit”: 10,
“items”: […]
}
This lets clients know how many total pages are available.