The latest articles on DEV Community by Derek Martin (@derek_martin_f24f9dcdd322). https://dev.to/derek_martin_f24f9dcdd322 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3875818%2F266b8625-c369-4f97-ba8e-d9fc500b498e.png https://dev.to/derek_martin_f24f9dcdd322 en Derek Martin Mon, 13 Apr 2026 03:45:57 +0000 https://dev.to/derek_martin_f24f9dcdd322/sqlalchemy-14-20-migration-tool-for-repetitive-legacy-patterns-3lce https://dev.to/derek_martin_f24f9dcdd322/sqlalchemy-14-20-migration-tool-for-repetitive-legacy-patterns-3lce <p>I built a scanner-first SQLAlchemy 1.4 -&gt; 2.0 migration tool for a narrow documented subset of legacy patterns.</p> <p>It is intentionally not a full "AI migration" promise. It handles supported patterns like:</p> <ul> <li>select([..])</li> <li>session.query(Model).get(pk)</li> <li>simple string relationship joins</li> <li>simple string loader options</li> <li>legacy declarative imports</li> <li>simple DML constructor keyword rewrites</li> </ul> <p>Unsupported patterns stay visible in a manual-review bucket, so the free scan can tell you whether a repo is even a fit before you pay for anything.</p> <p>Overview:<br> <a href="https://zippertools.org/sqlalchemy-migration-tool.html" rel="noopener noreferrer">https://zippertools.org/sqlalchemy-migration-tool.html</a></p> python opensource webdev programming