It would be nice to execute a query with row count and time limits. Row count is straight forward with an iterator wrapper.

For time limits it may be possible by doing something like:

• set a progress handler
• set a deadline in a context var in execute call
• in the progress handler, check to see if the deadline has been hit
• in a nested query, the deadline is whichever is sooner, the outside deadline or the inside deadline

I would be wise to implement #502 for the progress handler so multiple can co-exist.

Getting a monotonic clock is platform dependent. For python 3.13 there is an official API. For earlier releases the function py_get_monotonic_clock in the Python source Python/pytime.c has per platform headers and platform calls.