René's URL Explorer Experiment


Title: Joined table variable names should include source table name for disambiguation · Issue #560 · sqlc-dev/sqlc · GitHub

Open Graph Title: Joined table variable names should include source table name for disambiguation · Issue #560 · sqlc-dev/sqlc

X Title: Joined table variable names should include source table name for disambiguation · Issue #560 · sqlc-dev/sqlc

Description: Hi, great library! When using an SQL JOIN statement, we can end up with tables that have the same column name in the same variable interpolation. Currently, this results in names such as Name and Name_2. For example, given the following ...

Open Graph Description: Hi, great library! When using an SQL JOIN statement, we can end up with tables that have the same column name in the same variable interpolation. Currently, this results in names such as Name and N...

X Description: Hi, great library! When using an SQL JOIN statement, we can end up with tables that have the same column name in the same variable interpolation. Currently, this results in names such as Name and N...

Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/560

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Joined table variable names should include source table name for disambiguation","articleBody":"Hi, great library!\r\n\r\nWhen using an SQL JOIN statement, we can end up with tables that have the same column name in the same variable interpolation. Currently, this results in names such as `Name` and `Name_2`. For example, given the following schema:\r\n\r\n```sql\r\nCREATE EXTENSION IF NOT EXISTS pgcrypto;\r\n\r\nCREATE TABLE users (\r\n  id UUID gen_random_uuid (),\r\n  name TEXT\r\n)\r\n\r\nCREATE TABLE posts (\r\n  id UUID gen_random_uuid (),\r\n  user_id UUID REFERENCES users (id),\r\n  name TEXT\r\n)\r\n```\r\n\r\nAnd the following query:\r\n```sql\r\n-- name: GetPostsByUserByName :one\r\nSELECT * FROM posts\r\nLEFT JOIN users ON posts.user_id = users.id\r\nWHERE posts.name = $1 AND users.name = $2\r\n```\r\n\r\nWe end up with the following parameter type:\r\n```go\r\ntype GetPostsByUserByNameParams struct {\r\n\tName   uuid.UUID\r\n\tName_2 uuid.UUID\r\n}\r\n```\r\n\r\nThis is obviously not ideal, and I think we should do what SQL does for disambiguation; use the table names. It could look something like this (using the existing algorithm for de-pluralising table names):\r\n\r\n```go\r\ntype GetPostsByUserByNameParams struct {\r\n\tPostName uuid.UUID\r\n\tUserName uuid.UUID\r\n}\r\n```\r\n\r\nAlternatively, if that is too heavy handed, I tried using the `rename` functionality to override the variable name, but it doesn't seem to work as expected; the following accomplished nothing:\r\n\r\n```yaml\r\nrename:\r\n  posts.name: \"PostName\"\r\n  users.name: \"UserName\"\r\n```\r\n\r\nAny thoughts appreciated!","author":{"url":"https://github.com/johanbrandhorst","@type":"Person","name":"johanbrandhorst"},"datePublished":"2020-06-22T17:02:45Z","url":"https://github.com/sqlc-dev/sqlc/issues/560"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:72d9e949-6340-5ec1-d112-6df60c0380b6
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC0B8:2D02CB:4DD136:66B13B:6B0178B3
html-safe-nonce5dc2c0188c0ce375487245bbe5b5c0da7c3274266e6ded9d1ff9c2f7fd76c04e
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMEI4OjJEMDJDQjo0REQxMzY6NjZCMTNCOjZCMDE3OEIzIiwidmlzaXRvcl9pZCI6IjIwMzEzOTU3MjE3ODEwMTY3NTUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac2e9874144dbf432bcf31f8d2adfe4b96cc9d5fa0d9f0aa80506ffbf2070e3856
hovercard-subject-tagissue:643229151
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/560/issue_layout
twitter:imagehttps://opengraph.githubassets.com/2a995e4b4a0910e8549d247e2c6fddbc7a44a7364fa0af393ec40e375889f8e3/sqlc-dev/sqlc/issues/560
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/2a995e4b4a0910e8549d247e2c6fddbc7a44a7364fa0af393ec40e375889f8e3/sqlc-dev/sqlc/issues/560
og:image:altHi, great library! When using an SQL JOIN statement, we can end up with tables that have the same column name in the same variable interpolation. Currently, this results in names such as Name and N...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamejohanbrandhorst
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
go-importgithub.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id193160679
octolytics-dimension-repository_nwosqlc-dev/sqlc
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id193160679
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/issues/560#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F560
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
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
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://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/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F560
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/issues/560
Reloadhttps://github.com/sqlc-dev/sqlc/issues/560
Reloadhttps://github.com/sqlc-dev/sqlc/issues/560
sqlc-devhttps://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Codehttps://github.com/sqlc-dev/sqlc
Issues600 (600)https://github.com/sqlc-dev/sqlc/issues
Pull requests132 (132)https://github.com/sqlc-dev/sqlc/pulls
Discussionshttps://github.com/sqlc-dev/sqlc/discussions
Actionshttps://github.com/sqlc-dev/sqlc/actions
Projectshttps://github.com/sqlc-dev/sqlc/projects
Security and qualityhttps://github.com/sqlc-dev/sqlc/security
Insightshttps://github.com/sqlc-dev/sqlc/insights
https://github.com/sqlc-dev/sqlc
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/560
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/560
Joined table variable names should include source table name for disambiguationhttps://github.com/sqlc-dev/sqlc/issues/560#top
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
https://github.com/johanbrandhorst
johanbrandhorsthttps://github.com/johanbrandhorst
on Jun 22, 2020https://github.com/sqlc-dev/sqlc/issues/560#issue-643229151
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Jun 22, 2020https://github.com/sqlc-dev/sqlc/issues/560#issuecomment-647653250
named parametershttps://github.com/kyleconroy/sqlc/blob/master/docs/named_parameters.md
kyleconroyhttps://github.com/kyleconroy
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
on Jun 22, 2020https://github.com/sqlc-dev/sqlc/issues/560#event-3469390617
https://github.com/johanbrandhorst
johanbrandhorsthttps://github.com/johanbrandhorst
on Jun 22, 2020https://github.com/sqlc-dev/sqlc/issues/560#issuecomment-647659364
kyleconroyhttps://github.com/kyleconroy
completedhttps://github.com/sqlc-dev/sqlc/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 22, 2020https://github.com/sqlc-dev/sqlc/issues/560#event-3469439474
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/560
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/560
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
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.