René's URL Explorer Experiment


Title: gh-96165: Clarify omitting the FROM clause in SQLite queries. by felixxm · Pull Request #106513 · python/cpython · GitHub

Open Graph Title: gh-96165: Clarify omitting the FROM clause in SQLite queries. by felixxm · Pull Request #106513 · python/cpython

X Title: gh-96165: Clarify omitting the FROM clause in SQLite queries. by felixxm · Pull Request #106513 · python/cpython

Description: The Python programming language. Contribute to python/cpython development by creating an account on GitHub.

Open Graph Description: Issue: sqlite3 docs: explain SELECT-with-literals trick #96165 📚 Documentation preview 📚: https://cpython-previews--106513.org.readthedocs.build/

X Description: Issue: sqlite3 docs: explain SELECT-with-literals trick #96165 📚 Documentation preview 📚: https://cpython-previews--106513.org.readthedocs.build/

Opengraph URL: https://github.com/python/cpython/pull/106513

X: @github

direct link

Domain: github.com

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/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controllervoltron_pull_requests_fragments
route-actionpull_request_layout
fetch-noncev2:40acc6f3-85a6-ab12-ecd2-93c758cafb28
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB95C:3E418A:1E591C0:27C4498:6B022C79
html-safe-nonce0c4a7106e47a38e8407a5648e73c87f29a3394684b90375770c66eba093a6790
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCOTVDOjNFNDE4QToxRTU5MUMwOjI3QzQ0OTg6NkIwMjJDNzkiLCJ2aXNpdG9yX2lkIjoiMzIxNTk4NzE1MTI5MjQ3NjUzOCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac8c699c55102ae893f8dd362702849546fae2a5a57848bced10dbc8bd53685e92
hovercard-subject-tagpull_request:1424537555
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///voltron/pull_requests_fragments/pull_request_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/python/cpython/106513/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/48a6d6439179135850ec1c73cda9f6ee00131d06024ffb3efb92c6f6205d3651/python/cpython/pull/106513
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/48a6d6439179135850ec1c73cda9f6ee00131d06024ffb3efb92c6f6205d3651/python/cpython/pull/106513
og:image:altIssue: sqlite3 docs: explain SELECT-with-literals trick #96165 📚 Documentation preview 📚: https://cpython-previews--106513.org.readthedocs.build/
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamefelixxm
hostnamegithub.com
expected-hostnamegithub.com
None87e774ee7c6b3bee0490394e4d3e57ec9dbc956f74b87ea685dc8996c1676456
turbo-cache-controlno-cache
go-importgithub.com/python/cpython git https://github.com/python/cpython.git
octolytics-dimension-user_id1525981
octolytics-dimension-user_loginpython
octolytics-dimension-repository_id81598961
octolytics-dimension-repository_nwopython/cpython
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id81598961
octolytics-dimension-repository_network_root_nwopython/cpython
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
release423dbb54c5e7bfecc838eb387c1435eb3d0e760d
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-namepull-requests

Links:

Skip to contenthttps://github.com/python/cpython/pull/106513#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F106513
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%2Fpython%2Fcpython%2Fpull%2F106513
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%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=python%2Fcpython
Reloadhttps://github.com/python/cpython/pull/106513
Reloadhttps://github.com/python/cpython/pull/106513
Reloadhttps://github.com/python/cpython/pull/106513
pythonhttps://github.com/python
cpythonhttps://github.com/python/cpython
Codehttps://github.com/python/cpython
Issues5k+ (5k+)https://github.com/python/cpython/issues
Pull requests2.4k (2.4k)https://github.com/python/cpython/pulls
Actionshttps://github.com/python/cpython/actions
Projectshttps://github.com/python/cpython/projects
Security and qualityhttps://github.com/python/cpython/security
Insightshttps://github.com/python/cpython/insights
https://github.com/python/cpython
erlend-aaslandhttps://github.com/erlend-aasland
python:mainhttps://github.com/python/cpython/tree/main
felixxm:no-from-96165https://github.com/felixxm/cpython/tree/no-from-96165
Conversationhttps://github.com/python/cpython/pull/106513
Commits1 (1)https://github.com/python/cpython/pull/106513/commits
Checkshttps://github.com/python/cpython/pull/106513/checks
Files changedhttps://github.com/python/cpython/pull/106513/files
gh-96165: Clarify omitting the FROM clause in SQLite queries.https://github.com/python/cpython/pull/106513#top
erlend-aaslandhttps://github.com/erlend-aasland
python:mainhttps://github.com/python/cpython/tree/main
felixxm:no-from-96165https://github.com/felixxm/cpython/tree/no-from-96165
https://github.com/felixxm
felixxmhttps://github.com/felixxm
Jul 7, 2023https://github.com/python/cpython/pull/106513#issue-1793387941
Please reload this pagehttps://github.com/python/cpython/pull/106513
sqlite3 docs: explain SELECT-with-literals trick #96165https://github.com/python/cpython/issues/96165
https://cpython-previews--106513.org.readthedocs.build/https://cpython-previews--106513.org.readthedocs.build/
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/felixxm
felixxmhttps://github.com/felixxm
berkerpeksaghttps://github.com/berkerpeksag
erlend-aaslandhttps://github.com/erlend-aasland
code ownershttps://github.com/python/cpython/blob/24fb627ea7a4d57cf479b7516bafdb6c253a1645/.github/CODEOWNERS#L114
July 7, 2023 11:35https://github.com/python/cpython/pull/106513#event-9754109370
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
awaiting review https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22awaiting%20review%22
docs https://github.com/python/cpython/issues?q=state%3Aopen%20label%3Adocs
skip news https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22skip%20news%22
Jul 7, 2023https://github.com/python/cpython/pull/106513#event-9754109672
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
Jul 7, 2023 https://github.com/python/cpython/pull/106513#ref-issue-1345982684
sqlite3 docs: explain SELECT-with-literals trick #96165 https://github.com/python/cpython/issues/96165
https://github.com/erlend-aasland
erlend-aaslandhttps://github.com/erlend-aasland
Jul 7, 2023https://github.com/python/cpython/pull/106513#issuecomment-1625355119
@CAM-Gerlachhttps://github.com/CAM-Gerlach
@ezio-melottihttps://github.com/ezio-melotti
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/ezio-melotti
ezio-melottihttps://github.com/ezio-melotti
Jul 7, 2023 https://github.com/python/cpython/pull/106513#pullrequestreview-1518950688
View reviewed changes https://github.com/python/cpython/pull/106513/files
Doc/library/sqlite3.rsthttps://github.com/python/cpython/pull/106513/files#diff-e9385684db2b0ebe16c55670829d121faab7f91b9bd0f30767d4b399f696471f
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/ezio-melotti
ezio-melottihttps://github.com/ezio-melotti
Jul 7, 2023https://github.com/python/cpython/pull/106513#issuecomment-1625469502
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/felixxm
felixxmhttps://github.com/felixxm
Jul 7, 2023https://github.com/python/cpython/pull/106513#issuecomment-1625509251
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/felixxm
pythongh-96165https://github.com/python/cpython/issues/96165
: Clarify omitting the FROM clause in SQLite queries.https://github.com/python/cpython/pull/106513/commits/182c3a3b45a37cd7d668ca65d884ec1fe28717b2
182c3a3https://github.com/python/cpython/pull/106513/commits/182c3a3b45a37cd7d668ca65d884ec1fe28717b2
https://github.com/felixxm
felixxmhttps://github.com/felixxm
force-pushedhttps://github.com/python/cpython/compare/cdc98692c180c6c4d559659fa2895ace05408203..182c3a3b45a37cd7d668ca65d884ec1fe28717b2
cdc9869https://github.com/python/cpython/commit/cdc98692c180c6c4d559659fa2895ace05408203
182c3a3https://github.com/python/cpython/commit/182c3a3b45a37cd7d668ca65d884ec1fe28717b2
Compare https://github.com/python/cpython/compare/cdc98692c180c6c4d559659fa2895ace05408203..182c3a3b45a37cd7d668ca65d884ec1fe28717b2
July 7, 2023 14:36https://github.com/python/cpython/pull/106513#event-9755926681
https://github.com/felixxm
felixxmhttps://github.com/felixxm
Jul 7, 2023https://github.com/python/cpython/pull/106513#issuecomment-1625519347
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/erlend-aasland
erlend-aaslandhttps://github.com/erlend-aasland
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631441014
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/erlend-aasland
erlend-aaslandhttps://github.com/erlend-aasland
Jul 11, 2023 https://github.com/python/cpython/pull/106513#pullrequestreview-1525078131
View reviewed changes https://github.com/python/cpython/pull/106513/files/182c3a3b45a37cd7d668ca65d884ec1fe28717b2
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
awaiting merge https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22awaiting%20merge%22
awaiting review https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22awaiting%20review%22
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791813288
https://github.com/erlend-aasland
erlend-aaslandhttps://github.com/erlend-aasland
fc7ff1ahttps://github.com/python/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791831237
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
awaiting merge https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22awaiting%20merge%22
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791831615
https://github.com/erlend-aasland
erlend-aaslandhttps://github.com/erlend-aasland
needs backport to 3.11 https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22needs%20backport%20to%203.11%22
needs backport to 3.12 https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22needs%20backport%20to%203.12%22
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791833438
https://github.com/miss-islington
miss-islingtonhttps://github.com/miss-islington
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631444486
@felixxmhttps://github.com/felixxm
@erlend-aaslandhttps://github.com/erlend-aasland
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/miss-islington
miss-islingtonhttps://github.com/miss-islington
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631444497
@felixxmhttps://github.com/felixxm
@erlend-aaslandhttps://github.com/erlend-aasland
Please reload this pagehttps://github.com/python/cpython/pull/106513
miss-islingtonhttps://github.com/miss-islington
Jul 11, 2023 https://github.com/python/cpython/pull/106513#ref-commit-8c80fd1
https://github.com/felixxm
https://github.com/miss-islington
pythongh-96165https://github.com/python/cpython/issues/96165
: Clarify omitting the FROM clause in SQLite queries (https://github.com/miss-islington/cpython/commit/8c80fd15409614fee524e43b65a767b6c1f2352e
p…https://github.com/python/cpython/pull/106513
8c80fd1https://github.com/miss-islington/cpython/commit/8c80fd15409614fee524e43b65a767b6c1f2352e
…ythonGH-106513https://github.com/python/cpython/pull/106513
fc7ff1ahttps://github.com/miss-islington/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598
miss-islingtonhttps://github.com/miss-islington
Jul 11, 2023 https://github.com/python/cpython/pull/106513#ref-commit-5bcfc15
https://github.com/felixxm
https://github.com/miss-islington
pythongh-96165https://github.com/python/cpython/issues/96165
: Clarify omitting the FROM clause in SQLite queries (https://github.com/miss-islington/cpython/commit/5bcfc155d008f5e235cae3338ec1173e78e6b40c
p…https://github.com/python/cpython/pull/106513
5bcfc15https://github.com/miss-islington/cpython/commit/5bcfc155d008f5e235cae3338ec1173e78e6b40c
…ythonGH-106513https://github.com/python/cpython/pull/106513
fc7ff1ahttps://github.com/miss-islington/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631445175
GH-106645https://github.com/python/cpython/pull/106645
3.12 branchhttps://github.com/python/cpython/tree/3.12
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
needs backport to 3.12 https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22needs%20backport%20to%203.12%22
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791838360
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631445224
GH-106646https://github.com/python/cpython/pull/106646
3.11 branchhttps://github.com/python/cpython/tree/3.11
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/bedevere-bot
bedevere-bothttps://github.com/bedevere-bot
needs backport to 3.11 https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22needs%20backport%20to%203.11%22
Jul 11, 2023https://github.com/python/cpython/pull/106513#event-9791838660
https://github.com/felixxm
felixxmhttps://github.com/felixxm
Jul 11, 2023https://github.com/python/cpython/pull/106513#issuecomment-1631468171
@erlend-aaslandhttps://github.com/erlend-aasland
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/felixxm
felixxmhttps://github.com/felixxm
July 11, 2023 20:30https://github.com/python/cpython/pull/106513#event-9791995212
erlend-aaslandhttps://github.com/erlend-aasland
Jul 11, 2023 https://github.com/python/cpython/pull/106513#ref-commit-6d86623
https://github.com/miss-islington
https://github.com/felixxm
[3.11]https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab
gh-96165https://github.com/python/cpython/issues/96165
: Clarify omitting the FROM clause in SQLite queries (https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab
G…https://github.com/python/cpython/pull/106513
6d86623https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab
…H-106513https://github.com/python/cpython/pull/106513
#106646https://github.com/python/cpython/pull/106646
fc7ff1ahttps://github.com/python/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598
erlend-aaslandhttps://github.com/erlend-aasland
Jul 11, 2023 https://github.com/python/cpython/pull/106513#ref-commit-bf7e925
https://github.com/miss-islington
https://github.com/felixxm
[3.12]https://github.com/python/cpython/commit/bf7e92583dd33aa7e83d5929f2138c5d6957f571
gh-96165https://github.com/python/cpython/issues/96165
: Clarify omitting the FROM clause in SQLite queries (https://github.com/python/cpython/commit/bf7e92583dd33aa7e83d5929f2138c5d6957f571
G…https://github.com/python/cpython/pull/106513
bf7e925https://github.com/python/cpython/commit/bf7e92583dd33aa7e83d5929f2138c5d6957f571
…H-106513https://github.com/python/cpython/pull/106513
#106645https://github.com/python/cpython/pull/106645
fc7ff1ahttps://github.com/python/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598
https://github.co/hiddenchars
https://github.com/python/cpython/pull/{{ revealButtonHref }}
Sign up for freehttps://github.com/join?source=comment-repo
Sign in to commenthttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F106513
https://github.com/ezio-melotti
ezio-melotti https://github.com/ezio-melotti
https://github.com/python/cpython/pull/106513/files/cdc98692c180c6c4d559659fa2895ace05408203
https://github.com/erlend-aasland
erlend-aasland https://github.com/erlend-aasland
https://github.com/python/cpython/pull/106513/files/182c3a3b45a37cd7d668ca65d884ec1fe28717b2
https://github.com/berkerpeksag
berkerpeksag https://github.com/berkerpeksag
Please reload this pagehttps://github.com/python/cpython/pull/106513
docs https://github.com/python/cpython/issues?q=state%3Aopen%20label%3Adocs
skip news https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22skip%20news%22
Please reload this pagehttps://github.com/python/cpython/pull/106513
https://github.com/felixxm
https://github.com/erlend-aasland
https://github.com/ezio-melotti
https://github.com/miss-islington
https://github.com/bedevere-bot
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.