Is there any timeout parameter which could be setup at connection level, which is maximum amount of time a select query may take and if it is exceeding that parameter, query will just return an error code?

Thanks

You could write a progress handler that performs a timeout check.

https://sqlite.org/c3ref/progress_handler.html

Are you talking about this:

https://www.sqlite.org/pragma.html#pragma_busy_timeout

(with its equivalents which can be set through the API without a SQL command) ?

If you don't set up a busy handler, a SQL command which exceeds the timeout you set returns SQLITE_BUSY .

... a SQL command which exceeds the timeout you set returns SQLITE_BUSY .

i almost posted that one earlier as well, but the docs say that the busy handler is only applicable when waiting on a lock, as opposed waiting on a long-running query.

Yeah, I can't tell if that is actually what the OP wanted. But I thought it was worth a try. Will the kind of query they do need that kind of lock ? Can't tell until they post saying whether it works.

Yes, it works in contention waiting for lock, but as you said I need it for long-running query

Thanks, it should work