I would like to sort on a column with a round trip but no page reload. The table is very large and has to be paged in, which I am doing manually with an ajax select element. I know TableSort is available to extend the query but I've only seen examples that reload the page.
Why not to use Views module to display your data? Views already has AJAX paging, sorting and filtering.