Add query timeout setting to the Web Console #135

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