René's URL Explorer Experiment


Title: fix: MySQL parameter binding compatibility with SQLAlchemy by santinalbrowns · Pull Request #91 · sqlc-dev/sqlc-gen-python · GitHub

Open Graph Title: fix: MySQL parameter binding compatibility with SQLAlchemy by santinalbrowns · Pull Request #91 · sqlc-dev/sqlc-gen-python

X Title: fix: MySQL parameter binding compatibility with SQLAlchemy by santinalbrowns · Pull Request #91 · sqlc-dev/sqlc-gen-python

Description: Convert MySQL '?' placeholders to named parameters (':p1', ':p2', etc.) for proper SQLAlchemy parameter binding Add MySQL type mapping support for Python type inference Fix SQL syntax error when using generated code with MySQL + SQLAlchemy The generated code was using '?' placeholders in SQL but passing named parameters as dictionaries, which caused MySQL syntax errors. This fix ensures the SQL uses named parameters that match the parameter binding. Fixes parameter binding issues for MySQL users of sqlc-gen-python.

Open Graph Description: Convert MySQL '?' placeholders to named parameters (':p1', ':p2', etc.) for proper SQLAlchemy parameter binding Add MySQL type mapping support for Python type inference Fix ...

X Description: Convert MySQL '?' placeholders to named parameters (':p1', ':p2', etc.) for proper SQLAlchemy parameter binding Add MySQL type mapping support for Py...

Opengraph URL: https://github.com/sqlc-dev/sqlc-gen-python/pull/91

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:7e56c85f-c548-73db-3ca4-f445b6340f8b
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9B24:56B4A:40C192:5B76BC:696F9D35
html-safe-nonce8cc604d2515ecfdc4cb7c0326d1ccc5a893b069f3cf4e15cfbbd0a0dad01ce4c
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QjI0OjU2QjRBOjQwQzE5Mjo1Qjc2QkM6Njk2RjlEMzUiLCJ2aXNpdG9yX2lkIjoiOTA3NzE5NDc1OTQzOTYyMTQyOSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac17e91553a01a963c63703826cfa0118440948d6293251ae1a64f2727e1269e0f
hovercard-subject-tagpull_request:2745623542
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/sqlc-dev/sqlc-gen-python/pull/91/files
twitter:imagehttps://avatars.githubusercontent.com/u/60613674?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/60613674?s=400&v=4
og:image:altConvert MySQL '?' placeholders to named parameters (':p1', ':p2', etc.) for proper SQLAlchemy parameter binding Add MySQL type mapping support for Python type inference Fix ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0ca8d8c65612640b9a1a588b3eed68222ca723ed2d028b18fe81b28936d535eb
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/sqlc-dev/sqlc-gen-python git https://github.com/sqlc-dev/sqlc-gen-python.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id548530161
octolytics-dimension-repository_nwosqlc-dev/sqlc-gen-python
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id548530161
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc-gen-python
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release95f60616ce2765d1114fe6da4af405a58c6d26d2
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc-gen-python%2Fpull%2F91%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc-gen-python%2Fpull%2F91%2Ffiles
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=sqlc-dev%2Fsqlc-gen-python
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
sqlc-dev https://patch-diff.githubusercontent.com/sqlc-dev
sqlc-gen-pythonhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Fork 46 https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Star 304 https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Code https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Issues 33 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/issues
Pull requests 13 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulls
Actions https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/actions
Projects 0 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/projects
Security Uh oh! There was an error while loading. Please reload this page. https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/security
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Insights https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulse
Code https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Issues https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/issues
Pull requests https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulls
Actions https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/actions
Projects https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/projects
Security https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/security
Insights https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulse
Sign up for GitHub https://patch-diff.githubusercontent.com/signup?return_to=%2Fsqlc-dev%2Fsqlc-gen-python%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python%2Fissues%2Fnew%2Fchoose
santinalbrownshttps://patch-diff.githubusercontent.com/santinalbrowns
sqlc-dev:mainhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/tree/main
santinalbrowns:fix/mysql-parameter-bindinghttps://patch-diff.githubusercontent.com/santinalbrowns/sqlc-gen-python/tree/fix/mysql-parameter-binding
Conversation 1 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91
Commits 1 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/commits
Checks 0 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/checks
Files changed https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
fix: MySQL parameter binding compatibility with SQLAlchemy https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#top
Show all changes 1 commit https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
af18e1c fix: MySQL parameter binding compatibility with SQLAlchemy santinalbrowns Aug 14, 2025 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/commits/af18e1cf527644bd07d393fa5e7d11932009c52f
Clear filters https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files
gen.go https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
mysql_type.go https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-0ee8a056be54d833e9b1e647bcb9dd4883d9a8454a94a5a31fa5b801f39248c1
internal/gen.gohttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/af18e1cf527644bd07d393fa5e7d11932009c52f/internal/gen.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-8e745f10e32a54e4d9b0479fbd670007f1a9658bc9518177d5261b27ba46ba1c
internal/mysql_type.gohttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/files#diff-0ee8a056be54d833e9b1e647bcb9dd4883d9a8454a94a5a31fa5b801f39248c1
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/af18e1cf527644bd07d393fa5e7d11932009c52f/internal/mysql_type.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/91/{{ revealButtonHref }}
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.