Is it possible to run multiple queries at the same time?

[Gumichocopengin8]

When there are multiple queries in a query function. result only get the result of the first query.
Is there a way to get both results?
Is it even allowed to run multiple queries at the same time?

const result = await conn?.query('SELECT * FROM data_table; SHOW tables;');

[carlopi]

There is a way to get both results -> no, at the moment this needs to be split in two statements, like:

const result_first = await conn?.query('SELECT * FROM data_table;');
const result_second = await conn?.query('SHOW tables;');

Allowed -> yes

This is a bit quirky, I am looking into improving the API, might add another interface to execute multiple statement while getting all intermediate results.

[Gumichocopengin8]

Thank you for answering quickly. looking forward to seeing the API improvements soon :)