import re


def parse_multiline_sql(in_str):
    """
    Separates sql string composed of multiple statements into a list of strings
    :param in_str: The sql str
    :return:       A list of sql statements
    """
    regex = re.compile(r"""((?:[^;"']|"[^"]*"|'[^']*')+)""")
    results = []
    bad = ["", "/"]

    for p in regex.split(in_str)[1::2]:
        if p.strip() in bad:
            pass
        else:
            if p[0] == "\n":
                results.append(p[1:])
            elif p[:2] == "\r\n":
                results.append(p[2:])
            elif p[-1:] == "\n":
                results.append(p[:-1])
            elif p[-2:] == "\r\n":
                results.append(p[:-2])
            else:
                results.append(p)
    return results