Write actual SQL to retrieve your data.
- With SQLpy you can work directly with advanced SQL from the comfort of your Python code. Write SQL in .sql files and Python in .py files, with all the correct highlighting, linting and maintainability that comes with it.
- Write and run the exact SQL code you want
- Use advanced SQL techniques such as
- distinct on, partition over (), etc…
- Dynamically build SQL queries for different purposes
- Use the latest features available in your database system