3 ms·

It's fine advice - if you can type check your queries. My colleague wrote a mypy plugin for parsing SQL statements and doing type checking against a database sc

by rav 3y ago

It's fine advice - if you can type check your queries. My colleague wrote a mypy plugin for parsing SQL statements and doing type checking against a database schema file, which helps to identify typos and type errors early: https://github.com/antialize/py-mysql-type-plugin https://github.com/antialize/py-mysql-type-plugin

baq 3y ago
Raw sql doesn’t compose, so it’s a no go for me except in special cases, but the tool would be a great addition to sqlalchemy.core for when those special cases occur.
- javcasas 3y ago
  Here, go and read about the WITH statement https://modern-sql.com/feature/with https://modern-sql.com/feature/with
  - baq 3y ago
    That’s exactly when I write raw sql but being stuck on old Postgres versions has performance implications.