We have detected that Execute SQL script step has a limitation of approximately 256,000 characters. When the number of characters exceeds this limit, Filemaker fails to send the query to the driver.
This has been confirmed by Actual Technologies, ODBC driver for macOS
We are using:
File Maker 16.4
ODBC ActualTech ver 4.1.6