Extract parts from sql sentences with pyhton script

I have a .sql file with CREATE TABLE AND INSERTS TABLE sentences in it.
Example:

Extract parts from sql sentences with pyhton script

I have a .sql file with CREATE TABLE AND INSERTS TABLE sentences in it.
Example:

Extract parts from sql sentences with pyhton script

I have a .sql file with CREATE TABLE AND INSERTS TABLE sentences in it.
Example: