What is the best way to create a table with 800 columns in a single script?
The best way to run a very long script is not to load it into the editor, any editor.

Just reference it via @ and run it

So @my_script.sql and execute that.