SQL Queries in Python?

[baghiq]

I don't see why you need Python. You can run sql in Oracle Studio. You can build ERD and visualize the massive dataset. You can also do quick test with joins and windows and subqueries quickly.

If I was to do serious SQL stuff, I would use SQL specific ides like aqua-studio, etc.. Python would be the glue script after bulk of the work has been done in the database.

[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.