> Just allow them to cancel the query; use sqlite3_progress_handler(). I am using a third party data access component so this is out of my control.
If it computes many things and doesn't return many rows then I don't really care. I only want to know how many rows a query will return before I execute it in full. If I can tell that it is going to be a huge return data set then I can prompt them to change it.