sql: some operators don't seem to respect statement_timeout

SQLSmith has been repeatedly running into errors where it is timing out waiting for queries to execute that should be stopping due to taking longer than statement_timeout.

Example queries: https://github.com/cockroachdb/cockroach/issues/45433