If I do a database custom query with the contents of
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE tx_live_cust;
TRUNCATE TABLE tx_live_cust_live_ledger_balance;
SET FOREIGN_KEY_CHECKS = 1;
I get an error of, sorry the error is a bit older as I was trying a few things, so I know the error is missing the TABLE part, I tried a few different ways, until I figured out I had to split it up.
Only way around this is to split this into 4 custom queries, and have one command per query, I hardly ever use truncate in a script as that is normally more part of database management, so never really noticed this behaviour until now. Assuming it should not be adding \n between each command like that.