parse
Parses the supplied string and breaks it up into a list of strings The string needs to honor SQL comments and separates each SQL command into a list of strings, 1 string for each command. The list of queries is returned.
The script should have each command end in a semicolon, ; The best comment to use is #. All characters on a line after # will be stripped. Best to put # as the first character of a line with no further SQL on the line
Return
a list of strings representing each SQL command
Parameters
str
A big string that has SQL queries
Throws
the exception