Add query timeout setting to the Web Console

Is your feature request related to a problem?

By default all SQL queries timeout after 60 seconds. While this is OK for the majority of them, sometimes there is a need to run longer queries, for example to copy tables.

Describe the solution you'd like.

Add a setting in the console to set the query timeout. Pass the timeout in each query header:

https://questdb.io/docs/reference/api/rest/#headers

This could be done in web console UI, after a user runs a query which hits a timeout. Consider the case in screenshot:

At the bottom Log says timeout, query aborted [fd=104]. It would be useful to introduce some kind of a button to retry the query but with increased timeout limit.

Query used in screenshot:

CREATE TABLE readings AS(
  SELECT
    x ID,
    timestamp_sequence(
      to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'),
      rnd_long(1, 10, 0) * 100000L
    ) ts,
    rnd_double(0) * 8 + 15 temp,
    rnd_long(0, 10000, 0) sensorId
  FROM
    long_sequence(100000000L) x
) TIMESTAMP(ts) PARTITION BY MONTH

Start in the QuestDB Web Console by tracing where SQL queries are sent, then consult the linked REST API headers documentation for the timeout header. The work is done when the console offers a timeout setting or retry path and passes the selected timeout with each query request.