Advanced Parameters/SQL Manager

[Ian Ashton]

Is there any documentation on the SQL Manager in the Advanced Parameters Back Office menu?

Specifically what's allowed and not allowed or other restrictions.
I've been developing queries using mySQLWorkbench but failing to port them over to SQL Manager. 
Simple SELECTS seem to work but soon as I start adding JOINS etc I get errors.

Or are there any modules you'd recommend to run SQL against the database?

Or what other ways do people use for adding their own queries to their shop?

Running ThirtyBees 1.4.0/PHP 8.0

[datakick]

Most select queries should work. If not, please file issue on github.

Recently, we have fixed some issues in this area, so it's best if you could update to bleeding edge and test there.