for example:

sqls2="grant insert,update,delete on test.test1 to lili@192.168.11.23; grant update,insert,select on test1.test2 to lili2@10.10.11.12;"
for st in sp.split(sqls2):
... print(st)
...
grant insert,update,delete on test.test1 to lili@192.168.11.23; grant update,insert,select on test1.test2 to lili2@10.10.11.12; ---------in one line still

sqls2="grant insert,update,delete on test.test1 to lili@192.%; grant update,insert,select on test1.test2 to lili2@10.10.11.12;"
for st in sp.split(sqls2):
... print(st)
...
grant insert,update,delete on test.test1 to lili@192.%;
grant update,insert,select on test1.test2 to lili2@10.10.11.12; ----have been splited into. two lines

the differnence between two sqls is :

first sqls2 : lili@192.168.11.23
second sqls2: lili@192.%

sqlparse version is:

print(sp.version)
0.4.1