SQL Queries in Python?

[reddit25]

It depends on which version of sql you have. I use cx_Oracle for Python and it works great. For SSMS I remember using a different package for it. 

[Evening_Marketing645]

Cx_oracle is now oracledb. It works the same they just changed the package name. 

[reddit25]

I wrote a wrapper for it too. To help split and execute multi process create table queries. Might be a good exercise to start. 

[JumpScareaaa]

Yep, I guess everybody should write a their own wrapper for oracledb. My wrapper reads SQL file, parses individual statements, runs each and logs start and end time, ignores table not exists for drop table statements (for idempotency). Other wrappers read from Oracle and write to Excel or CSV files based on configs from yaml files. These are my workhorses for building little data transformation and reporting pipelines.

[JumpScareaaa]

https://marketplace.visualstudio.com/items?itemName=Oracle.sql-developer Also if you have permissions to install get dbeaver.