Is it possible to run multiple SQL statements in the SQL query section of ARI data tables. For example, I might want to update a table first or even create a new table, then display values from that table.
If I have only one SQL select query my table works fine. If I try to include a create or update statement before that I get the message 'No available data'.
Thanks.

Hello,

The module doesn't support described ability. It requires a custom development.

Regards,
ARI Soft

Are you able to do the custom development? Would you charge for that, given that you can add it as a feature to the module for sale?
Alternatively, can you tell me which files and which sections of those files need to be changed and I will do it.
Thanks for your help.

We can do this custom development. If you are interested in it, contact us by email so we can discuss details.

If you want to implement the feature by yourself, you can add new parameter (where a user will enter queries which should be executed before "SELECT" query) to module manifest file and modify <joomla_directory>\modules\mod_aridatatables\includes\kernel\DataTables\Models\class.DataTablesDataSqlModel.php file.

Regards,
ARI Soft