{"id":32,"date":"2024-12-04T20:58:52","date_gmt":"2024-12-04T20:58:52","guid":{"rendered":"https:\/\/codegenblog.kinsta.cloud\/?p=32"},"modified":"2025-09-04T15:38:03","modified_gmt":"2025-09-04T15:38:03","slug":"case-study-ai-powered-sqlalchemy-upgrade","status":"publish","type":"post","link":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/","title":{"rendered":"Case Study: AI-Powered SQLAlchemy Upgrade"},"content":{"rendered":"\n

Upgrading your tech stack is like cleaning out your closet. You know it needs to happen, but, ah, it\u2019s such a headache.<\/p>\n\n\n\n

But what if an AI tool could handle the heavy lifting for you? Today we’ll go through a case study on how Codegen\u2019s AI can safely automate your migration from SQLAlchemy 1.6 to 2.0.<\/strong><\/p>\n\n\n\n

Why Upgrade to 2.0?<\/h4>\n\n\n\n

SQLAlchemy 2.0 makes your code cleaner, less error-prone, and more maintainable. By upgrading, you get streamlined ORM functionality for query handling and APIs, AsyncIO support, type annotations, removal of implicit aliasing, and more.<\/p>\n\n\n\n

But manually upgrading to 2.0 is hard. Numerous APIs and ORM methods have been deprecated or changed. Overlooking even a small detail can cause messy runtime errors.<\/p>\n\n\n\n

How Codegen Automates the Migration<\/h4>\n\n\n\n
    \n
  1. With our proprietary static analysis software, we index your entire codebase and build a map of how everything depends on each other.<\/li>\n\n\n\n
  2. Our AI refactors your code to use the latest APIs and patterns from SQLAlchemy 2.0. Thanks to the static analysis, we ensure that changes are comprehensive and won\u2019t break either upstream or downstream dependencies.<\/li>\n\n\n\n
  3. We run your unit tests and lint rules against the changes to ensure there were no errors or regressions.<\/li>\n\n\n\n
  4. <\/li>\n<\/ol>\n\n\n\n

    Case Study: Codegen’s Automated Migration<\/h4>\n\n\n\n

    This Github repo<\/a> shows a before-and-after comparison of a Codegen-assisted SQLAlchemy 2.0 migration for a simple book-tracking app. The migration guide breaks it down into a series of Codemods, such as this one<\/a> that updates all files to adhere to SQLAlchemy2.0 class inheritance protocol:<\/p>\n\n\n\n

    \"\"
    Fork this codemod on run on any codebase, and it’ll generate a diff updating your SQLAlchemy class inheritance protocols.<\/figcaption><\/figure>\n\n\n\n

    Here are some highlighted diffs from the complete migration.<\/p>\n\n\n\n

    Removing implicit autocommit<\/strong><\/h6>\n\n\n\n
    \"\"
    By adhering to 2.0 syntax, we reduce the chances of unintended side effects and ensure the connection is properly closed<\/figcaption><\/figure>\n\n\n\n
    Updating query syntax to use where()<\/code> and select()<\/code> constructs<\/strong><\/h6>\n\n\n\n
    \"\"
    Instead of query and filter, we use the updated select and where statements.<\/figcaption><\/figure>\n\n\n\n
    Using new relationship loading techniques<\/strong><\/h6>\n\n\n\n
    \"\"
    With lazy=”selectin”, we invoke a SQLAlchemy 2.0 lazy-loading strategy that loads related objects using a single additional query with an IN clause, instead of executing multiple subqueries.<\/figcaption><\/figure>\n\n\n\n

    Personally, I\u2019m getting a migraine just thinking about making all these updates by hand, even for a simple CRUD app like this. <\/p>\n\n\n\n

    Set up a demo<\/a> to get started with Codegen today!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Upgrading your tech stack is like cleaning out your closet. You know it needs to happen, but, ah, it\u2019s such a headache. But what if an AI tool could handle the heavy lifting for you? Today we’ll go through a case study on how Codegen\u2019s AI can safely automate your migration from SQLAlchemy 1.6 to 2.0. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[6,5],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-case-studies-and-demos","category-codemods-and-refactoring"],"acf":[],"yoast_head":"\nCase Study: AI-Powered SQLAlchemy Upgrade - The Codegen Blog<\/title>\n<meta name=\"description\" content=\"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Case Study: AI-Powered SQLAlchemy Upgrade\" \/>\n<meta property=\"og:description\" content=\"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/\" \/>\n<meta property=\"og:site_name\" content=\"The Codegen Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-04T20:58:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-04T15:38:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1305\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Codegen Technical Staff\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@codegen\" \/>\n<meta name=\"twitter:site\" content=\"@codegen\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Codegen Technical Staff\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/\"},\"author\":{\"name\":\"Codegen Technical Staff\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#\\\/schema\\\/person\\\/d11d8bf8745420c643fcb0f3213aa92f\"},\"headline\":\"Case Study: AI-Powered SQLAlchemy Upgrade\",\"datePublished\":\"2024-12-04T20:58:52+00:00\",\"dateModified\":\"2025-09-04T15:38:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/\"},\"wordCount\":397,\"publisher\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp\",\"articleSection\":[\"Case Studies & Demos\",\"Codemods & Refactoring\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/\",\"url\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/\",\"name\":\"Case Study: AI-Powered SQLAlchemy Upgrade - The Codegen Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp\",\"datePublished\":\"2024-12-04T20:58:52+00:00\",\"dateModified\":\"2025-09-04T15:38:03+00:00\",\"description\":\"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#primaryimage\",\"url\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp\",\"contentUrl\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/case-study-ai-powered-sqlalchemy-upgrade\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/codegen.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Study: AI-Powered SQLAlchemy Upgrade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/codegen.com\\\/blog\\\/\",\"name\":\"The Codegen Blog\",\"description\":\"What we\u2019re building, how we\u2019re building it, and what we\u2019re learning along the way.\",\"publisher\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/codegen.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#organization\",\"name\":\"Codegen\",\"url\":\"https:\\\/\\\/codegen.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Codegen_Lockup-Black-1024h-scaled.png\",\"contentUrl\":\"https:\\\/\\\/codegenblog.kinsta.cloud\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Codegen_Lockup-Black-1024h-scaled.png\",\"width\":2560,\"height\":528,\"caption\":\"Codegen\"},\"image\":{\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/codegen\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/codegen.com\\\/blog\\\/#\\\/schema\\\/person\\\/d11d8bf8745420c643fcb0f3213aa92f\",\"name\":\"Codegen Technical Staff\",\"sameAs\":[\"https:\\\/\\\/codegenblog.kinsta.cloud\"],\"url\":\"https:\\\/\\\/codegen.com\\\/blog\\\/author\\\/cg-admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Case Study: AI-Powered SQLAlchemy Upgrade - The Codegen Blog","description":"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/","og_locale":"en_US","og_type":"article","og_title":"Case Study: AI-Powered SQLAlchemy Upgrade","og_description":"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.","og_url":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/","og_site_name":"The Codegen Blog","article_published_time":"2024-12-04T20:58:52+00:00","article_modified_time":"2025-09-04T15:38:03+00:00","og_image":[{"width":1920,"height":1305,"url":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp","type":"image\/webp"}],"author":"Codegen Technical Staff","twitter_card":"summary_large_image","twitter_creator":"@codegen","twitter_site":"@codegen","twitter_misc":{"Written by":"Codegen Technical Staff","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#article","isPartOf":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/"},"author":{"name":"Codegen Technical Staff","@id":"https:\/\/codegen.com\/blog\/#\/schema\/person\/d11d8bf8745420c643fcb0f3213aa92f"},"headline":"Case Study: AI-Powered SQLAlchemy Upgrade","datePublished":"2024-12-04T20:58:52+00:00","dateModified":"2025-09-04T15:38:03+00:00","mainEntityOfPage":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/"},"wordCount":397,"publisher":{"@id":"https:\/\/codegen.com\/blog\/#organization"},"image":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp","articleSection":["Case Studies & Demos","Codemods & Refactoring"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/","url":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/","name":"Case Study: AI-Powered SQLAlchemy Upgrade - The Codegen Blog","isPartOf":{"@id":"https:\/\/codegen.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#primaryimage"},"image":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp","datePublished":"2024-12-04T20:58:52+00:00","dateModified":"2025-09-04T15:38:03+00:00","description":"Discover how an AI-powered upgrade can simplify your migration to SQLAlchemy 2.0 and enhance your tech stack effortlessly.","breadcrumb":{"@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#primaryimage","url":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp","contentUrl":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/687687e4cbd48f5d961994ee_6751fd6eb33bf6e8fa2198af_6751fcc7b33bf6e8fa2120a7_sql0.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/codegen.com\/blog\/case-study-ai-powered-sqlalchemy-upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/codegen.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Case Study: AI-Powered SQLAlchemy Upgrade"}]},{"@type":"WebSite","@id":"https:\/\/codegen.com\/blog\/#website","url":"https:\/\/codegen.com\/blog\/","name":"The Codegen Blog","description":"What we\u2019re building, how we\u2019re building it, and what we\u2019re learning along the way.","publisher":{"@id":"https:\/\/codegen.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/codegen.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/codegen.com\/blog\/#organization","name":"Codegen","url":"https:\/\/codegen.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/codegen.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/Codegen_Lockup-Black-1024h-scaled.png","contentUrl":"https:\/\/codegenblog.kinsta.cloud\/wp-content\/uploads\/2025\/07\/Codegen_Lockup-Black-1024h-scaled.png","width":2560,"height":528,"caption":"Codegen"},"image":{"@id":"https:\/\/codegen.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/codegen"]},{"@type":"Person","@id":"https:\/\/codegen.com\/blog\/#\/schema\/person\/d11d8bf8745420c643fcb0f3213aa92f","name":"Codegen Technical Staff","sameAs":["https:\/\/codegenblog.kinsta.cloud"],"url":"https:\/\/codegen.com\/blog\/author\/cg-admin\/"}]}},"_links":{"self":[{"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":5,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":21803,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions\/21803"}],"wp:attachment":[{"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codegen.com\/blog\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}