René's URL Explorer Experiment


Title: [BUG] column with names that are keywords cant be escaped in views · Issue #349 · stackql/stackql · GitHub

Open Graph Title: [BUG] column with names that are keywords cant be escaped in views · Issue #349 · stackql/stackql

X Title: [BUG] column with names that are keywords cant be escaped in views · Issue #349 · stackql/stackql

Description: Describe the bug If a response body has a top level field which is a keyword, such as desc it can be escaped in a naked SELECT statement, but the same statement fails in a view To Reproduce stackql >>CREATE VIEW vw_formula_urls AS SELECT...

Open Graph Description: Describe the bug If a response body has a top level field which is a keyword, such as desc it can be escaped in a naked SELECT statement, but the same statement fails in a view To Reproduce stackql...

X Description: Describe the bug If a response body has a top level field which is a keyword, such as desc it can be escaped in a naked SELECT statement, but the same statement fails in a view To Reproduce stackql...

Opengraph URL: https://github.com/stackql/stackql/issues/349

X: @github

direct link

Domain: github.com

Hey, it has json ld scripts: 
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] column with names that are keywords cant be escaped in views","articleBody":"**Describe the bug**\r\nIf a response body has a top level field which is a keyword, such as `desc` it can be escaped in a naked `SELECT` statement, but the same statement fails in a view\r\n\r\n**To Reproduce**\r\n```\r\nstackql  \u003e\u003eCREATE VIEW vw_formula_urls AS SELECT * FROM (SELECT name as formula_name, homepage, \"desc\" as description FROM homebrew.formula.formula) t;\r\nDDL Execution Completed\r\nstackql  \u003e\u003eSELECT * FROM vw_formula_urls WHERE formula_name = 'stackql';\r\nerror:  You have an error in your stackql syntax; parser error: Code: INVALID_ARGUMENT\r\nsyntax error at position 59 near 'desc'\r\n```\r\n","author":{"url":"https://github.com/jeffreyaven","@type":"Person","name":"jeffreyaven"},"datePublished":"2023-12-21T03:17:09.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/349/stackql/issues/349"}
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:20f7bc49-7258-93af-4c7a-b0fcbd80a656
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idE898:13B1D:1ACA44B:25BE24F:6A4CC396
html-safe-noncecfeeea0e0f70de03e0f32302fea0aa2e63c9ff107ef8ef4a0b150a2f2c297971
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFODk4OjEzQjFEOjFBQ0E0NEI6MjVCRTI0Rjo2QTRDQzM5NiIsInZpc2l0b3JfaWQiOiI2NjI2Mjg2NTU4MzQ4MzYyNjQ2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac2e576f047e8b5662939693c6b91fc4afc6923fa0690ff6c4366bb0df6e7f093d
hovercard-subject-tagissue:2051620084
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/stackql/stackql/349/issue_layout
twitter:imagehttps://opengraph.githubassets.com/b36c6c8b2774ea54f94c973eeedf4b895c4a149d84bf6d43bc37a648e9c68159/stackql/stackql/issues/349
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/b36c6c8b2774ea54f94c973eeedf4b895c4a149d84bf6d43bc37a648e9c68159/stackql/stackql/issues/349
og:image:altDescribe the bug If a response body has a top level field which is a keyword, such as desc it can be escaped in a naked SELECT statement, but the same statement fails in a view To Reproduce stackql...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamejeffreyaven
hostnamegithub.com
expected-hostnamegithub.com
None3d11bb817438277de2a940854450e83a7d32b6aeb5014e9e6b00a6423900251c
turbo-cache-controlno-preview
go-importgithub.com/stackql/stackql git https://github.com/stackql/stackql.git
octolytics-dimension-user_id95105302
octolytics-dimension-user_loginstackql
octolytics-dimension-repository_id443987542
octolytics-dimension-repository_nwostackql/stackql
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id443987542
octolytics-dimension-repository_network_root_nwostackql/stackql
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
released0da0eb92994395299ed4450bf67b0373005be36
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/stackql/stackql/issues/349#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fstackql%2Fstackql%2Fissues%2F349
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
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
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
GitHub Starshttps://stars.github.com
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://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fstackql%2Fstackql%2Fissues%2F349
Sign up https://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=stackql%2Fstackql
Reloadhttps://github.com/stackql/stackql/issues/349
Reloadhttps://github.com/stackql/stackql/issues/349
Reloadhttps://github.com/stackql/stackql/issues/349
Please reload this pagehttps://github.com/stackql/stackql/issues/349
stackql https://github.com/stackql
stackqlhttps://github.com/stackql/stackql
Please reload this pagehttps://github.com/stackql/stackql/issues/349
Notifications https://github.com/login?return_to=%2Fstackql%2Fstackql
Fork 80 https://github.com/login?return_to=%2Fstackql%2Fstackql
Star 861 https://github.com/login?return_to=%2Fstackql%2Fstackql
Code https://github.com/stackql/stackql
Issues 101 https://github.com/stackql/stackql/issues
Pull requests 1 https://github.com/stackql/stackql/pulls
Discussions https://github.com/stackql/stackql/discussions
Actions https://github.com/stackql/stackql/actions
Projects https://github.com/stackql/stackql/projects
Wiki https://github.com/stackql/stackql/wiki
Security and quality 0 https://github.com/stackql/stackql/security
Insights https://github.com/stackql/stackql/pulse
Code https://github.com/stackql/stackql
Issues https://github.com/stackql/stackql/issues
Pull requests https://github.com/stackql/stackql/pulls
Discussions https://github.com/stackql/stackql/discussions
Actions https://github.com/stackql/stackql/actions
Projects https://github.com/stackql/stackql/projects
Wiki https://github.com/stackql/stackql/wiki
Security and quality https://github.com/stackql/stackql/security
Insights https://github.com/stackql/stackql/pulse
[BUG] column with names that are keywords cant be escaped in viewshttps://github.com/stackql/stackql/issues/349#top
https://github.com/jeffreyaven
bugSomething isn't workinghttps://github.com/stackql/stackql/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/jeffreyaven
jeffreyavenhttps://github.com/jeffreyaven
on Dec 21, 2023https://github.com/stackql/stackql/issues/349#issue-2051620084
jeffreyavenhttps://github.com/jeffreyaven
bugSomething isn't workinghttps://github.com/stackql/stackql/issues?q=state%3Aopen%20label%3A%22bug%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.