it is possible to write a query in full

eduardorpm

it is possible to write a query in full,i have difficulties whit complex querys

allan

If you are using the Editor PHP libraries, absolutely: https://editor.datatables.net/docs/current/php/class-DataTables.Database.html#_sql .

I should also say that the Editor PHP libraries are designed to cater for the 80% part of the "market". There will always be actions that they won't cope with as they are designed to provide a simple interface. For such cases, the Editor client-server communication protocol is documented here: https://editor.datatables.net/server/

Regards,
Allan