How can i insert bulk data into the SQL server using python

Sqlalchemy is the most common way and has a ton of flexibility. Pandas or dataset are other alternatives that aren't orms as much. Peewee orm is good if you want something light weight.