Query Result Table is deleted when is empty

[jesus-hergueta]

Issue Summary

When a query returns 0 rows the query result table is deleted and is not possible to use it in another queries, giving this error:

Error running query: Error creating table query_28: near ")": syntax error.

If I run this: SELECT name FROM sqlite_master WHERE type='table' AND name='query_28'; gives 0 rows, the table does not exists.

Steps to Reproduce

1. Create a Query, that returns data (Data Source: JSON API)
2. Make the Query return 0 rows.
3. Try to consume the Query anywhere else using Query Results as source.

In my opinion the table should exists while the query does, emptiness is not a real reason to delete the table.

Technical details:

• Redash Version:
• Browser/OS: Chrome 129.0.6668.90
• How did you install Redash: I'm running Redash in Docker Compose hosted in a EC2 machine.