# SQL

SQL is a standardized database language for defining, accessing, and manipulating data in relational databases.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## CVE-2026-77367 - Daptin: Unauthenticated SQL Injection via the \`sort\` query parameter on every entity list endpoint

DevFeed: [CVE-2026-77367 - Daptin: Unauthenticated SQL Injection via the \`sort\` query parameter on every entity list endpoint](<https://devfeed.tech/articles/cve-2026-77367-daptin-unauthenticated-sql-injection-via-the-sort-query-parameter-on-every-entity-list-endpoint-143947.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-77367>)

Author: CVEFEED.io; github.com

Published: 2026-11-19T17:18:59Z

Content type: news

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [GraphQL](<https://devfeed.tech/topics/graphql.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [api](<https://devfeed.tech/tags/api.md>), [can](<https://devfeed.tech/tags/can.md>), [cms](<https://devfeed.tech/tags/cms.md>), [column](<https://devfeed.tech/tags/column.md>), [critical](<https://devfeed.tech/tags/critical.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-77367](<https://devfeed.tech/tags/cve-2026-77367.md>), [cvss](<https://devfeed.tech/tags/cvss.md>), [daptin](<https://devfeed.tech/tags/daptin.md>), [error](<https://devfeed.tech/tags/error.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [graphql](<https://devfeed.tech/tags/graphql.md>), [headless](<https://devfeed.tech/tags/headless.md>), [identifier](<https://devfeed.tech/tags/identifier.md>), [list](<https://devfeed.tech/tags/list.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sort](<https://devfeed.tech/tags/sort.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>)

### AI overview

Before Daptin 0.12.30, the generic GET /api/{entity} list endpoint accepts unvalidated, attacker-controlled `sort` values. In PaginatedFindAllWithoutFilters, those values are used to construct SELECT and ORDER BY identifiers without checking them against the table schema; an embedded quote can break out of the quoted identifier and alter SQL parsing. The excerpt says unauthenticated attackers may extract unauthorized table data through blind or error-based behavior, or repeatedly trigger query failures. The issue is fixed in version 0.12.30.

### Source excerpt

CVE ID :CVE-2026-77367 Published : Nov. 19, 2026, 5:18 p.m. | 26 minutes ago Description :Daptin is a GraphQL/JSON-API headless CMS. Prior to 0.12.30, the generic GET /api/{entity} list endpoint accepts attacker-controlled sort values in PaginatedFindAllWithoutFilters in server/resource/resource_findallpaginated.go without validating the requested column against the table schema. The code uses those values for SELECT and ORDER BY identifier construction, so an embedded identifier quote can terminate the quoted identifier and make the remainder parse as SQL, allowing an unauthenticated attacker to extract unauthorized table data through blind or error-based behavior or repeatedly trigger query failures. This issue is fixed in version 0.12.30. Severity: 9.4 | CRITICAL Visit the link for more details, such as CVSS details, affected products, timeline, and more...

## MetaSieve: Faster Relational Deep Learning through SQL-Based Metapath Selection

DevFeed: [MetaSieve: Faster Relational Deep Learning through SQL-Based Metapath Selection](<https://devfeed.tech/articles/metasieve-faster-relational-deep-learning-through-sql-based-metapath-selection-142283.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2608.25903>)

Author: Fahim Shahriar Khan, Ashraf Aboulnaga

Published: 2026-11-19T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>), [arXiv: Machine Learning](<https://devfeed.tech/sources/arxiv-machine-learning.md>)

Topics: [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [JOIN](<https://devfeed.tech/topics/join.md>), [Neural Network](<https://devfeed.tech/topics/neural-network.md>), [Deep neural networks](<https://devfeed.tech/topics/deep-neural-networks.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [cs-db](<https://devfeed.tech/tags/cs-db.md>), [cs-lg](<https://devfeed.tech/tags/cs-lg.md>), [deep-learning](<https://devfeed.tech/tags/deep-learning.md>), [evaluation](<https://devfeed.tech/tags/evaluation.md>), [faster](<https://devfeed.tech/tags/faster.md>), [gnn](<https://devfeed.tech/tags/gnn.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [selection](<https://devfeed.tech/tags/selection.md>), [sql](<https://devfeed.tech/tags/sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

MetaSieve reduces the subgraphs used to train relational graph neural networks by pruning metapaths that appear uninformative, aiming to cut training time while maintaining accuracy. For each candidate metapath extension, it uses SQL joins and aggregations to calculate statistics, then scores the candidate for low cost and informativeness; extensions below a threshold are pruned. The selection layer relies on database statistics and task labels, not GNN parameters, and is designed to work with different GNN architectures for classification and regression. On RelBench with multiple GNN backbones, the authors report large per-epoch training-time reductions while maintaining and often improving accuracy.

### Source excerpt

arXiv:2608.25903v2 Announce Type: replace Abstract: Relational Deep Learning (RDL) is an effective approach to machine learning over multi-table relational databases. In RDL, a database is modeled as a graph in which each row is a node and each foreign-key relation is an edge, and a graph neural network (GNN) is trained on this graph. Training a GNN requires sampling a subgraph around every seed node in the training set, and the cost of training is largely determined by the size of these subgraphs. This paper aims to reduce subgraph size by leveraging the join and aggregation capabilities of relational database systems. We observe that sampled subgraphs are obtained by following metapaths composed of foreign-key links, and that many of these metapaths can be pruned without loss of accuracy. We present MetaSieve, a metapath selection layer that determines which metapaths to retain and which to prune. For each candidate metapath extension, MetaSieve computes statistics via SQL join and aggregation queries and evaluates the extension based on a novel scoring function that prefers lightweight but informative candidates. Metapaths whose scores fall below a threshold are deemed uninformative and pruned. Metapath selection in MetaSieve is lightweight since it relies only on database statistics and task labels, and it is independent of GNN parameters, so it integrates with diverse GNN architectures for classification and regression. Our evaluation on the RelBench benchmark with multiple GNN backbones shows that MetaSieve consistently reduces per-epoch training time by large margins while maintaining and often improving accuracy.

## Logical Design Tuning via Workload-aware E/R-to-Relational Mapping

DevFeed: [Logical Design Tuning via Workload-aware E/R-to-Relational Mapping](<https://devfeed.tech/articles/logical-design-tuning-via-workload-aware-e-r-to-relational-mapping-142287.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.23632>)

Author: Hasara Kalumin, Amol Deshpande

Published: 2026-11-19T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [schema design](<https://devfeed.tech/topics/schema-design.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>)

Tags: [applications](<https://devfeed.tech/tags/applications.md>), [approach](<https://devfeed.tech/tags/approach.md>), [arxiv](<https://devfeed.tech/tags/arxiv.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [based](<https://devfeed.tech/tags/based.md>), [challenge](<https://devfeed.tech/tags/challenge.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [data](<https://devfeed.tech/tags/data.md>), [design](<https://devfeed.tech/tags/design.md>), [designer](<https://devfeed.tech/tags/designer.md>), [execution](<https://devfeed.tech/tags/execution.md>), [execution-plan](<https://devfeed.tech/tags/execution-plan.md>), [existing](<https://devfeed.tech/tags/existing.md>), [experiments](<https://devfeed.tech/tags/experiments.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [flexibility](<https://devfeed.tech/tags/flexibility.md>), [framework](<https://devfeed.tech/tags/framework.md>), [inheritance](<https://devfeed.tech/tags/inheritance.md>), [logical](<https://devfeed.tech/tags/logical.md>), [mapping](<https://devfeed.tech/tags/mapping.md>)

### AI overview

The paper presents a cost-based framework that chooses a relational schema for an E/R model using a representative workload. It optimizes choices for inheritance and entity and relationship representations, then compiles user E/R queries to SQL so existing relational optimizers can choose physical plans. Experiments on real-world-inspired schemas report that fixed and heuristic mappings vary widely in performance across workloads, while the proposed method achieves competitive performance and avoids pathological cases. The supplied text does not provide quantitative results or implementation details.

### Source excerpt

arXiv:2611.23632v1 Announce Type: new Abstract: Conceptual data models, like the E/R model, can provide a more stable and intuitive user-facing interface and better logical independence for applications, compared to the relational model which is forced to closely mirror the physical representation. However, this flexibility introduces a challenge as well as an opportunity: a single conceptual schema admits many semantically equivalent relational schemas, whose performance can differ substantially across workloads. Traditional mapping methods use a set of predefined transformation rules or designer-selected mapping strategies, rather than optimizing the relational realization with respect to the expected workload. In this paper, we present a cost-based framework for workload-aware conceptual-to-relational mapping. Given an E/R schema and a representative workload, our framework automatically selects an efficient relational schema by optimizing mapping decisions, including inheritance, entity and relationship representations. User-specified E/R queries are compiled into SQL over the selected relational realization, allowing existing relational query optimizers to determine the physical execution plan. Experiments on real-world-inspired schemas show that mapping choices strongly affect performance; fixed or heuristic strategies exhibit large variability across workloads, whereas our approach consistently achieves competitive performance avoiding pathological cases.

## Sync Engine: Mirror WorkOS data into your database

DevFeed: [Sync Engine: Mirror WorkOS data into your database](<https://devfeed.tech/articles/sync-engine-mirror-workos-data-into-your-database-146297.md>)

Original publisher: [Read original article](<https://workos.com/blog/sync-engine>)

Author: WorkOS

Published: 2026-11-19T00:00:00Z

Content type: article

Language: en

Sources: [WorkOS](<https://devfeed.tech/sources/workos-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-coding](<https://devfeed.tech/tags/ai-coding.md>), [ai-coding-agent](<https://devfeed.tech/tags/ai-coding-agent.md>), [api](<https://devfeed.tech/tags/api.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [bi-tools](<https://devfeed.tech/tags/bi-tools.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [identity](<https://devfeed.tech/tags/identity.md>), [mirror](<https://devfeed.tech/tags/mirror.md>), [organizations](<https://devfeed.tech/tags/organizations.md>), [query](<https://devfeed.tech/tags/query.md>), [records](<https://devfeed.tech/tags/records.md>), [sync](<https://devfeed.tech/tags/sync.md>), [users](<https://devfeed.tech/tags/users.md>), [workos](<https://devfeed.tech/tags/workos.md>)

### AI overview

WorkOS Sync Engine mirrors users, organizations, memberships, permissions, and emitted events into a database you control, letting applications join identity records with their own data in one database query. It supports Postgres, MySQL, MongoDB, and ClickHouse; generated `_live` views omit tombstoned rows, while retained deletion records can support investigation of departures within the records the mirror captured and still retains. Joins should include `_env` because IDs are unique per environment. Install `@workos/sync-engine` and a destination package, run it as a TypeScript library or Docker service, backfill existing records, keep the Events API poller running, and schedule reconciliation separately for supported streams. Polling and database write frequency are configurable within API rate limits. Permissions can be read alongside application data, but access decisions remain on the session token.

### Source excerpt

The WorkOS Sync Engine mirrors users, organizations, and memberships into your database, so you can query identity data alongside your application records.

## CVE-2026-55508 - Wavelog has unauthenticated SQL injection in the OQRS callsign log search

DevFeed: [CVE-2026-55508 - Wavelog has unauthenticated SQL injection in the OQRS callsign log search](<https://devfeed.tech/articles/cve-2026-55508-wavelog-has-unauthenticated-sql-injection-in-the-oqrs-callsign-log-search-141201.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-55508>)

Author: CVEFEED.io; github.com

Published: 2026-11-18T20:44:30Z

Content type: news

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Credential theft](<https://devfeed.tech/topics/credential-theft.md>), [Secrets Management](<https://devfeed.tech/topics/secrets-management.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [account](<https://devfeed.tech/tags/account.md>), [administrator](<https://devfeed.tech/tags/administrator.md>), [api](<https://devfeed.tech/tags/api.md>), [api-keys](<https://devfeed.tech/tags/api-keys.md>), [credentials](<https://devfeed.tech/tags/credentials.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-55508](<https://devfeed.tech/tags/cve-2026-55508.md>), [database](<https://devfeed.tech/tags/database.md>), [disclosure](<https://devfeed.tech/tags/disclosure.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [logging](<https://devfeed.tech/tags/logging.md>), [metadata](<https://devfeed.tech/tags/metadata.md>), [parameter](<https://devfeed.tech/tags/parameter.md>), [password](<https://devfeed.tech/tags/password.md>), [password-reset](<https://devfeed.tech/tags/password-reset.md>), [post](<https://devfeed.tech/tags/post.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>), [wavelog](<https://devfeed.tech/tags/wavelog.md>)

### AI overview

Before Wavelog 2.5, the unauthenticated POST /oqrs/search_log endpoint passes its callsign parameter into a raw SQL clause without parameter binding. A remote attacker can exploit this with UNION-based SQL injection to read application records, including credentials and password reset tokens; the tokens may enable account takeover, including of administrator accounts. The issue is fixed in version 2.5.

### Source excerpt

CVE ID :CVE-2026-55508 Published : Nov. 18, 2026, 8:44 p.m. | 37 minutes ago Description :Wavelog is web-based amateur radio logging software. Prior to 2.5, the callsign parameter accepted by POST /oqrs/search_log in application/controllers/Oqrs.php search_log() reaches application/models/Oqrs_model.php search_log(), where it is concatenated directly into a raw SQL WHERE clause without parameter binding. An unauthenticated remote attacker can use UNION-based SQL injection to read arbitrary application database records, including account data, password hashes, API keys, station credentials, reset tokens, QSO data, and station metadata. Disclosure of password reset tokens can be combined with the forgot_password workflow to take over accounts, including administrator accounts. This issue is fixed in version 2.5. Severity: 9.4 | CRITICAL Visit the link for more details, such as CVSS details, affected products, timeline, and more...

## MoL-SQL: A Controlled Benchmark for Mixture-of-Language Text-to-SQL

DevFeed: [MoL-SQL: A Controlled Benchmark for Mixture-of-Language Text-to-SQL](<https://devfeed.tech/articles/mol-sql-a-controlled-benchmark-for-mixture-of-language-text-to-sql-140630.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.22333>)

Author: Tianqi Luo, Boyan Li, Yuyu Luo

Published: 2026-11-18T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>)

Tags: [alignment](<https://devfeed.tech/tags/alignment.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [context](<https://devfeed.tech/tags/context.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [database](<https://devfeed.tech/tags/database.md>), [evaluation](<https://devfeed.tech/tags/evaluation.md>), [execution](<https://devfeed.tech/tags/execution.md>), [language](<https://devfeed.tech/tags/language.md>), [llms](<https://devfeed.tech/tags/llms.md>), [mapping](<https://devfeed.tech/tags/mapping.md>), [question](<https://devfeed.tech/tags/question.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [translation](<https://devfeed.tech/tags/translation.md>), [values](<https://devfeed.tech/tags/values.md>)

### AI overview

MoL-SQL tests how question, schema, and stored-value languages independently affect Text-to-SQL while keeping each task aligned. Its pipeline maps cross-lingual entities, migrates databases with constraints, checks rewritten SQL for execution equivalence, and regenerates questions from verified queries. The benchmark includes MoL-Full (16,892 samples) for overall evaluation and MoL-Cube (3,840) for comparing every language combination. Experiments across eight LLMs and four method families found distinct schema and value effects; stored-value language reduced accuracy by up to 23 points, mainly through cross-lingual entity mapping. Question translation and extra reasoning did not close that value gap, while access to target-database values substantially reduced it.

### Source excerpt

arXiv:2611.22333v1 Announce Type: new Abstract: Text-to-SQL systems are usually built and evaluated under a monolingual assumption, yet in international applications users often query databases stored in a different language. Existing multilingual benchmarks mostly translate only the question without aligning schema and value entities, so they can neither locate the source of an accuracy drop nor rule out translation errors. Hence, we introduce MoL-SQL, a benchmark for mixture-of-language Text-to-SQL that switches the languages of the question, schema, and stored values independently while keeping each task fixed, and grades every cross-lingual entity mapping into four difficulty levels. We migrate five Text-to-SQL benchmarks of different domains and source languages through a unified alignment pipeline that builds a shared cross-lingual entity map, migrates each database with its constraints, rewrites the gold SQL under execution-equivalence checks, and regenerates the question from the verified SQL, keeping all language versions of a task aligned in entities, intent, and execution result. MoL-SQL provides two splits: MoL-Full (16,892 samples) for overall evaluation and MoL-Cube (3,840 samples) covering every language combination to isolate question, schema, and value effects. Experiments with eight LLMs and four families of Text-to-SQL methods show that schema and value languages have distinct effects, with stored values costing up to 23 points, and that these effects mainly stem from cross-lingual entity mapping. Neither question translation nor additional reasoning narrows the value gap, whereas access to target-database values substantially reduces it, indicating that mixture-of-language Text-to-SQL benefits most from language-aware context grounding.

## CVE-2026-131850 - ILIAS 11.0 before 11.6 SQL Injection via Registration Codes Table Sorting

DevFeed: [CVE-2026-131850 - ILIAS 11.0 before 11.6 SQL Injection via Registration Codes Table Sorting](<https://devfeed.tech/articles/cve-2026-131850-ilias-11-0-before-11-6-sql-injection-via-registration-codes-table-sorting-139373.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-131850>)

Author: CVEFEED.io; vulncheck.com

Published: 2026-11-18T00:18:42Z

Content type: news

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>)

Tags: [cve-2026-131850](<https://devfeed.tech/tags/cve-2026-131850.md>), [ilias](<https://devfeed.tech/tags/ilias.md>), [sorting](<https://devfeed.tech/tags/sorting.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>)

### AI overview

ILIAS versions 11.0 through before 11.6 have a high-severity SQL injection vulnerability in RegistrationCodeRepository::getCodesData(). The method places unvalidated sort fields into an ORDER BY clause. An authenticated user with read access to the Authentication and Registration administration node can pass SQL expressions as the sort parameter and infer database contents through boolean-based queries. The excerpt gives no remediation details.

### Source excerpt

CVE ID :CVE-2026-131850 Published : Nov. 18, 2026, 12:18 a.m. | 1 hour, 24 minutes ago Description :ILIAS 11.0 before 11.6 contains an sql injection vulnerability in RegistrationCodeRepository::getCodesData() that concatenates unvalidated sort fields into an ORDER BY clause. Authenticated users with read access to the Authentication and Registration administration node can supply SQL expressions as the sort parameter to extract database contents via boolean-based inference. Severity: 8.6 | HIGH Visit the link for more details, such as CVSS details, affected products, timeline, and more...

## MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more

DevFeed: [MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more](<https://devfeed.tech/articles/mssql-extension-for-vs-code-local-azure-sql-database-provisioning-query-performance-dashboard-and-more-140691.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/vscode-mssql-november2026/>)

Author: Yo-Lei Chen

Published: 2026-11-17T22:03:17Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [VS Code Extension](<https://devfeed.tech/topics/vscode-extension.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [container](<https://devfeed.tech/tags/container.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [database](<https://devfeed.tech/tags/database.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [dev](<https://devfeed.tech/tags/dev.md>), [development](<https://devfeed.tech/tags/development.md>), [extension](<https://devfeed.tech/tags/extension.md>), [github-copilot](<https://devfeed.tech/tags/github-copilot.md>), [local](<https://devfeed.tech/tags/local.md>), [mssql](<https://devfeed.tech/tags/mssql.md>), [net](<https://devfeed.tech/tags/net.md>), [performance](<https://devfeed.tech/tags/performance.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [query](<https://devfeed.tech/tags/query.md>), [sql](<https://devfeed.tech/tags/sql.md>), [visual-studio-code](<https://devfeed.tech/tags/visual-studio-code.md>), [vs-code](<https://devfeed.tech/tags/vs-code.md>), [vscode-mssql](<https://devfeed.tech/tags/vscode-mssql.md>), [wizard](<https://devfeed.tech/tags/wizard.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

MSSQL extension for VS Code v1.48 adds three public previews: local Azure SQL Database containers, a local-to-cloud deployment wizard, and a Query Performance Dashboard. The container runs the Azure SQL engine locally without an Azure subscription, supports Docker, Podman, nerdctl, and WSL containers, and can be managed from VS Code; cloud-specific behavior still needs testing against Azure SQL Database. The deployment wizard checks compatibility and copies schema only or schema and data to a new Azure SQL Database, but requires a running local database and an Azure subscription with resource-creation permissions. The dashboard surfaces Query Store query costs, history, waits, and plans; Query Store must be enabled with captured workload data, and users need read permission. The release also previews multi-results grids and live query statistics, adds nested connection groups, and improves Data API builder redeployment and local CLI workflows, including Microsoft Entra database authentication.

### Source excerpt

A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands [...] The post MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more appeared first on Azure SQL Dev Corner.

## Fuzzy string matching is now generally available across Microsoft SQL

DevFeed: [Fuzzy string matching is now generally available across Microsoft SQL](<https://devfeed.tech/articles/fuzzy-string-matching-is-now-generally-available-across-microsoft-sql-140689.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/fuzzy-string-matching-is-now-generally-available-across-microsoft-sql/>)

Author: Abhiman Tiwari

Published: 2026-11-17T20:54:16Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Entity resolution](<https://devfeed.tech/topics/entity-resolution.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [azure-sql-managed-instance](<https://devfeed.tech/tags/azure-sql-managed-instance.md>), [edit-distance](<https://devfeed.tech/tags/edit-distance.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [fuzzy-string-matching](<https://devfeed.tech/tags/fuzzy-string-matching.md>), [managed-instance](<https://devfeed.tech/tags/managed-instance.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [native](<https://devfeed.tech/tags/native.md>), [similarity](<https://devfeed.tech/tags/similarity.md>), [sql-database-in-fabric](<https://devfeed.tech/tags/sql-database-in-fabric.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [string-matching](<https://devfeed.tech/tags/string-matching.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>)

### AI overview

Microsoft SQL now offers four native T-SQL fuzzy matching functions across Azure SQL Database, Azure SQL Managed Instance, SQL database in Microsoft Fabric, and SQL Server 2025 CU11 or later. `EDIT_DISTANCE` uses restricted Damerau-Levenshtein (Optimal String Alignment) to count insertions, deletions, substitutions, and transpositions; its optional distance limit returns the actual count within the limit and limit + 1 when exceeded. `EDIT_DISTANCE_SIMILARITY` normalizes that count. Jaro-Winkler functions score character resemblance, including a fixed shared-prefix preference, so they can rank names but may score distinct organizations highly. These scores indicate resemblance, not identity or probability. The article recommends narrowing candidates with trusted attributes before comparing, validating cutoffs on labeled data, and confirming likely matches with independent evidence. Inputs require supported Windows or binary collations, bounded character types, and return NULL for NULL inputs; `varchar(max)` and `nvarchar(max)` are unsupported.

### Source excerpt

Four native T-SQL functions that tell you how close two strings are, not just whether they're equal. MICROSFT isn't MICROSOFT. MARHTA isn't MARTHA. INV-1O08 isn't INV-1008. To an equality check, each pair is simply different. To your business, each is a near miss worth catching. Today, fuzzy string matching is generally available in Microsoft SQL. EDIT_DISTANCE tells you MICROSFT is one edit from MICROSOFT. JARO_WINKLER_SIMILARITY scores MARTHA and MARHTA at 96 out of 100. [...] The post Fuzzy string matching is now generally available across Microsoft SQL appeared first on Azure SQL Dev Corner.

## QuarkDB: A Hybrid Database System for Quantum Data Management

DevFeed: [QuarkDB: A Hybrid Database System for Quantum Data Management](<https://devfeed.tech/articles/quarkdb-a-hybrid-database-system-for-quantum-data-management-138302.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.20807>)

Author: Wenrui Zhang, Yu Wang, Xiao Zhang

Published: 2026-11-17T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>)

Tags: [cs-ar](<https://devfeed.tech/tags/cs-ar.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [data-management](<https://devfeed.tech/tags/data-management.md>), [database](<https://devfeed.tech/tags/database.md>), [execution](<https://devfeed.tech/tags/execution.md>), [hybrid](<https://devfeed.tech/tags/hybrid.md>), [quantum](<https://devfeed.tech/tags/quantum.md>), [query](<https://devfeed.tech/tags/query.md>), [query-engine](<https://devfeed.tech/tags/query-engine.md>), [storage](<https://devfeed.tech/tags/storage.md>), [version](<https://devfeed.tech/tags/version.md>)

### AI overview

QuarkDB unifies relational and quantum data in one object model and defines a Quantum Structured Query Language. Its hybrid query engine selects cost-based plans across classical and quantum operators; its execution engine uses a three-level QuarkDB-IR to support quantum execution and reduce processing costs; and its storage engine supports version management, state reconstruction, and data reuse. The abstract reports query-latency speedups of 2.14x to 25.86x versus SQLite, PostgreSQL, and Qute across the authors' real-world workloads. It provides no workload-specific results or evaluation details in the supplied excerpt.

### Source excerpt

arXiv:2611.20807v1 Announce Type: new Abstract: Emerging quantum applications like quantum communication generate large volumes of high-dimensional quantum data, requiring efficient data analysis and storage. However, classical database systems often struggle to meet requirements such as quantum processing or version management. This paper presents QuarkDB designed for efficient quantum data management. QuarkDB establishes a unified object model for relational and quantum data and defines the syntax of Quantum Structured Query Language. To support efficient quantum data management, QuarkDB integrates three key components: (1) a Hybrid Query Engine with cost-based hybrid plan selection over classical and quantum operators, (2) an Execution Engine with a three-level instructions intermediate representation, QuarkDB-IR, to support quantum execution and reduce quantum processing costs, and (3) a Storage Engine supporting quantum data version management, state reconstruction and data reuse. Compared with classical databases such as SQLite and PostgreSQL or quantum databases like Qute, our QuarkDB achieves query-latency speedups ranging from 2.14x to 25.86x speedup under extensive real-world workloads.

## What's new across Microsoft SQL at Microsoft Ignite 2026

DevFeed: [What's new across Microsoft SQL at Microsoft Ignite 2026](<https://devfeed.tech/articles/what-s-new-across-microsoft-sql-at-microsoft-ignite-2026-140692.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/whats-new-across-microsoft-sql-at-microsoft-ignite-2026/>)

Author: Anna Hoffman

Published: 2026-11-16T23:40:42Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-developer](<https://devfeed.tech/tags/ai-developer.md>), [ai-powered](<https://devfeed.tech/tags/ai-powered.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [applications](<https://devfeed.tech/tags/applications.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [dev](<https://devfeed.tech/tags/dev.md>), [ignite](<https://devfeed.tech/tags/ignite.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-ignite](<https://devfeed.tech/tags/microsoft-ignite.md>), [microsoft-ignite-2026](<https://devfeed.tech/tags/microsoft-ignite-2026.md>), [microsoft-sql](<https://devfeed.tech/tags/microsoft-sql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

Microsoft's Ignite 2026 SQL announcements emphasize modernization to Azure SQL Database Hyperscale, local development, and database operations. Hyperscale cross-database queries are in preview to reduce rewrites for applications with database dependencies; other updates include GA fuzzy matching, regex-based masking, and AES customer-managed TDE keys, plus preview per-database managed identities. Modernize CLI assesses application and database dependencies together, while Database Hub adds estate-wide views and preview agent-assisted assessments, investigations, recommendations, and alerts. Developers can use a public-preview local Azure SQL container and a preview VS Code wizard for deployment to Azure SQL Database. The excerpt also lists updates for Managed Instance, SQL database in Fabric, SQL Server, Azure tooling, and SSMS; availability varies by feature, with many items explicitly marked preview or GA.

### Source excerpt

From Microsoft Ignite I'm here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It's a cool energy to be surrounded by so many people at organizations that are trying to innovate with AI for the era of AI. These applications are the apps [...] The post What's new across Microsoft SQL at Microsoft Ignite 2026 appeared first on Azure SQL Dev Corner.

## CVE-2026-130082 - django-tenants 3.4.8 before 4.0.1 SQL Injection via Unescaped Schema Name

DevFeed: [CVE-2026-130082 - django-tenants 3.4.8 before 4.0.1 SQL Injection via Unescaped Schema Name](<https://devfeed.tech/articles/cve-2026-130082-django-tenants-3-4-8-before-4-0-1-sql-injection-via-unescaped-schema-name-136279.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-130082>)

Author: CVEFEED.io; vulncheck.com

Published: 2026-11-16T22:18:24Z

Content type: article

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Django](<https://devfeed.tech/topics/django.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [alter](<https://devfeed.tech/tags/alter.md>), [cve-2026-130082](<https://devfeed.tech/tags/cve-2026-130082.md>), [database](<https://devfeed.tech/tags/database.md>), [django-tenants](<https://devfeed.tech/tags/django-tenants.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [search-path](<https://devfeed.tech/tags/search-path.md>), [sql-injection](<https://devfeed.tech/tags/sql-injection.md>)

### AI overview

django-tenants versions 3.4.8 through before 4.0.1 have a SQL injection vulnerability in the PostgreSQL backend. An attacker able to choose or influence a tenant schema name can use quote characters that are interpolated without escaping into `SET search_path` and `CREATE`, `DROP`, or `ALTER SCHEMA` statements. The stated impact is access to other tenants' data or SQL execution as the application's database user. The source rates severity 8.8 (High).

### Source excerpt

CVE ID :CVE-2026-130082 Published : Nov. 16, 2026, 10:18 p.m. | 36 minutes ago Description :django-tenants 3.4.8 before 4.0.1 contains an SQL injection vulnerability in its PostgreSQL backend that allows attackers to inject SQL through unescaped tenant schema names. Attackers who can choose or influence a schema name can supply quote characters that are interpolated into SET search_path and CREATE, DROP or ALTER SCHEMA statements, letting them read other tenants' data or run SQL as the application's database user. Severity: 8.8 | HIGH Visit the link for more details, such as CVSS details, affected products, timeline, and more...

## Talk to your clinical data: unlocking AWS HealthLake with OpenSharing and Genie One

DevFeed: [Talk to your clinical data: unlocking AWS HealthLake with OpenSharing and Genie One](<https://devfeed.tech/articles/talk-to-your-clinical-data-unlocking-aws-healthlake-with-opensharing-and-genie-one-136420.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/talk-your-clinical-data-unlocking-aws-healthlake-opensharing-and-genie-one>)

Author: Michael McCarthy; Lily Goldstein; Douglas Moore

Published: 2026-11-16T18:30:00Z

Content type: article

Language: en

Sources: [Databricks](<https://devfeed.tech/sources/databricks.md>)

Topics: [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [AWS Lake Formation](<https://devfeed.tech/topics/aws-lake-formation.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [API](<https://devfeed.tech/topics/api.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>)

Tags: [accelerate](<https://devfeed.tech/tags/accelerate.md>), [access-controls](<https://devfeed.tech/tags/access-controls.md>), [accessible](<https://devfeed.tech/tags/accessible.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-use](<https://devfeed.tech/tags/ai-use.md>), [aws](<https://devfeed.tech/tags/aws.md>), [data](<https://devfeed.tech/tags/data.md>), [genie](<https://devfeed.tech/tags/genie.md>), [healthcare](<https://devfeed.tech/tags/healthcare.md>), [healthcare-and-life-sciences](<https://devfeed.tech/tags/healthcare-and-life-sciences.md>), [healthcare-life-sciences](<https://devfeed.tech/tags/healthcare-life-sciences.md>), [industries](<https://devfeed.tech/tags/industries.md>), [life](<https://devfeed.tech/tags/life.md>), [life-sciences](<https://devfeed.tech/tags/life-sciences.md>), [manage](<https://devfeed.tech/tags/manage.md>), [one](<https://devfeed.tech/tags/one.md>), [opensharing](<https://devfeed.tech/tags/opensharing.md>), [organizations](<https://devfeed.tech/tags/organizations.md>), [talk](<https://devfeed.tech/tags/talk.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

The described OpenSharing integration lets Databricks query AWS HealthLake's FHIR data directly, avoiding export pipelines and duplicate copies. A custom OpenSharing server deployed as a Databricks App obtains temporary Lake Formation credentials, resolves each table's current Iceberg snapshot, and returns pre-signed data files; Databricks compute reads them directly from S3, so data does not pass through the server. OIDC federation lets AWS trust the app's Databricks identity. Unity Catalog governs shared-catalog access with grants and fine-grained, attribute-based, and role-based controls, and supports auditing. Curated Genie Agents can provide natural-language exploration, generating SQL and returning summarized answers, tables, and charts subject to Unity Catalog permissions. The text presents this as an option for Databricks analytics, notebooks, dashboards, and AI, alongside existing Athena or Redshift paths, and points to a reference implementation deployed as a Declarative Automation Bundle.

### Source excerpt

Many healthcare and life sciences organizations have standardized on AWS HealthLake to manage clinical data...

## Euler meets Codd

DevFeed: [Euler meets Codd](<https://devfeed.tech/articles/euler-meets-codd-135998.md>)

Original publisher: [Read original article](<https://neo4j.com/blog/developer/euler-meets-codd/>)

Author: christoffer bergman

Published: 2026-11-16T11:43:00Z

Content type: article

Language: en

Sources: [Neo4j](<https://devfeed.tech/sources/graph-database-technology-neo4j-blog.md>)

Topics: [Neo4j](<https://devfeed.tech/topics/neo4j.md>), [graph-database](<https://devfeed.tech/topics/graph-database.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [graph theory](<https://devfeed.tech/topics/graph-theory.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [Snowflake streaming data architecture](<https://devfeed.tech/topics/snowflake-streaming-data-architecture.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [aura](<https://devfeed.tech/tags/aura.md>), [aura-graph-analytics](<https://devfeed.tech/tags/aura-graph-analytics.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [cypher](<https://devfeed.tech/tags/cypher.md>), [cypher-gql](<https://devfeed.tech/tags/cypher-gql.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [developer](<https://devfeed.tech/tags/developer.md>), [fraud-detection](<https://devfeed.tech/tags/fraud-detection.md>), [graph](<https://devfeed.tech/tags/graph.md>), [knowledge-graph](<https://devfeed.tech/tags/knowledge-graph.md>), [neo4j](<https://devfeed.tech/tags/neo4j.md>), [query](<https://devfeed.tech/tags/query.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [sql](<https://devfeed.tech/tags/sql.md>), [virtual-graph](<https://devfeed.tech/tags/virtual-graph.md>)

### AI overview

Neo4j Virtual Graphs let users query relational data in Databricks with Cypher and explore it through Neo4j graph tools without copying the data. In a fraud-ring example, the author maps account and transaction tables to graph nodes and relationships, then finds chronologically ordered, decreasing transfers that return to their starting account. A bounded query returned the same rings as a native Neo4j graph, taking about 25 seconds versus 1.5 seconds; the author cautions this was not a scientific benchmark. Virtual Graphs provide graph query expression and visualization, but not native graph traversal speed, and the example required an upper bound because unbounded variable-length queries are unsupported. The described setup uses Aura, a paid feature requiring a credit card. The article says users can later import the data into a native graph using the same data source and model.

### Source excerpt

Neo4j Virtual Graph lets you query relational data in Databricks, Snowflake, BigQuery and similar platforms with Cypher/GQL, using Neo4j's full suite of graph tools.

## LuthorSQL: A One-Pass Text-to-SQL Model as System 1 for a Slower LLM Agent

DevFeed: [LuthorSQL: A One-Pass Text-to-SQL Model as System 1 for a Slower LLM Agent](<https://devfeed.tech/articles/luthorsql-a-one-pass-text-to-sql-model-as-system-1-for-a-slower-llm-agent-135111.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.17780>)

Author: Ibrahim Memon, Armin Karamzade, M. Hanif Jhaveri, Roy Fox

Published: 2026-11-16T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Artificial Intelligence](<https://devfeed.tech/sources/arxiv-artificial-intelligence.md>), [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>), [arXiv: Machine Learning](<https://devfeed.tech/sources/arxiv-machine-learning.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [LLM optimization](<https://devfeed.tech/topics/llm-optimization.md>), [quantization](<https://devfeed.tech/topics/quantization.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [autoregressive](<https://devfeed.tech/tags/autoregressive.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [cascade](<https://devfeed.tech/tags/cascade.md>), [claude](<https://devfeed.tech/tags/claude.md>), [claude-opus-5-5](<https://devfeed.tech/tags/claude-opus-5-5.md>), [confidence](<https://devfeed.tech/tags/confidence.md>), [cost](<https://devfeed.tech/tags/cost.md>), [costs](<https://devfeed.tech/tags/costs.md>), [cs-ai](<https://devfeed.tech/tags/cs-ai.md>), [cs-cl](<https://devfeed.tech/tags/cs-cl.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [cs-lg](<https://devfeed.tech/tags/cs-lg.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [execution](<https://devfeed.tech/tags/execution.md>), [external](<https://devfeed.tech/tags/external.md>), [llm](<https://devfeed.tech/tags/llm.md>), [model](<https://devfeed.tech/tags/model.md>), [sql](<https://devfeed.tech/tags/sql.md>), [system](<https://devfeed.tech/tags/system.md>), [text](<https://devfeed.tech/tags/text.md>)

### AI overview

LuthorSQL is a local 7B text-to-SQL model designed to handle confident queries in one forward pass and send uncertain ones to a slower LLM agent. It scores query-plan slots under a bounded grammar, runs up to 32 candidate plans, and selects with a trained validator. On BIRD's hidden test set it achieved 68.03% execution accuracy at 0.84 seconds per question on one GPU; 8-bit quantization preserved accuracy in 9 GB, and zero-shot results on five other databases were within 3.1 points of SQLite. In a pre-registered cascade with Claude Opus 5.5 on 227 post-cutoff database questions, it answered nearly half locally and reduced API cost 33.3% at the same accuracy. The abstract also reports substantial verbatim reproduction of public benchmark queries by Opus, while its tool-assisted accuracy held on renamed schemas and reached 95.6-97.4% on post-cutoff databases.

### Source excerpt

arXiv:2611.17780v1 Announce Type: cross Abstract: Frontier LLM agents that query databases with tools are among the most accurate text-to-SQL systems, but per-query calls to a hosted model are slow, costly, and expose sensitive organizational queries to external APIs. For example, a Claude Opus 5.5 agent serving 10,000 queries a day costs over $70,000 a year at list price. To what extent can local hardware already owned by an organization offload this burden without compromising the agent's accuracy? We present LuthorSQL, a non-autoregressive 7B text-to-SQL model that serves as a rapid System 1 gate for a slower LLM agent (System 2), escalating queries only when uncertain. LuthorSQL makes a single forward pass to predict slot scores over a bounded grammar for query plans, compiles and runs up to 32 candidate plans, and chooses an answer using a trained validator. On its own, LuthorSQL reaches 68.03% execution accuracy on BIRD's hidden test set at 0.84 s per question on a single GPU, maintains its accuracy in 9 GB with 8-bit quantized weights, and transfers zero-shot to Snowflake, BigQuery, MySQL, PostgreSQL, and DuckDB within 3.1 points of its native SQLite accuracy. Combined with Claude Opus 5.5 in a pre-registered confidence cascade over 227 questions on databases published after Opus's training cutoff, LuthorSQL answers nearly half of all questions locally and cuts API cost by 33.3% at the same accuracy. Finally, contamination probing shows that Opus reproduces 48-92% of public benchmark gold queries verbatim without seeing the schema; however, its tool-assisted accuracy holds on renamed schemas and reaches 95.6-97.4% on post-cutoff databases. Code and data: https://github.com/IAMIbrahimmemon/luthorsql

## MEM-SQL: Memory-Empowered Text-to-SQL

DevFeed: [MEM-SQL: Memory-Empowered Text-to-SQL](<https://devfeed.tech/articles/mem-sql-memory-empowered-text-to-sql-135446.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.18338>)

Author: Xiaoqi Wang, Wenqi Pei, Shizheng Hou, Yilai Liu, Han Chen, Boyan Li, Yuyu Luo, Hongyang Du

Published: 2026-11-16T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [JOIN](<https://devfeed.tech/topics/join.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [domain](<https://devfeed.tech/tags/domain.md>), [edits](<https://devfeed.tech/tags/edits.md>), [execution](<https://devfeed.tech/tags/execution.md>), [generation](<https://devfeed.tech/tags/generation.md>), [history](<https://devfeed.tech/tags/history.md>), [join](<https://devfeed.tech/tags/join.md>), [language-models](<https://devfeed.tech/tags/language-models.md>), [latency](<https://devfeed.tech/tags/latency.md>), [layer](<https://devfeed.tech/tags/layer.md>), [linking](<https://devfeed.tech/tags/linking.md>), [mappings](<https://devfeed.tech/tags/mappings.md>), [memory](<https://devfeed.tech/tags/memory.md>), [queries](<https://devfeed.tech/tags/queries.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

MEM-SQL uses verified query history to improve Text-to-SQL accuracy while reducing generation cost. Its HARE benchmark contains 1,600 requests derived from 823 verified queries across four datasets, with annotations distinguishing whole-query adaptation from partial reuse. MEM-SQL stores query templates, reusable SQL blocks, and mappings from domain concepts to schema elements; it uses a layer only when all its assigned requirements match above a threshold. On-demand Schema Linking consults the schema when no layer qualifies or retrieved evidence seems insufficient. Across six language models on HARE, mean execution accuracy rose from 37.1% for direct generation without history to 50.0%, while input tokens fell 76.6% and latency 68.8% on average. Reusing several queries remains difficult: accuracy fell from 56.7% to 29.7%, especially when components must be reorganized or combined around a shared join. OSL reduced generation cost for three other memory designs, but its accuracy effect depended on the design.

### Source excerpt

arXiv:2611.18338v1 Announce Type: new Abstract: Text-to-SQL systems translate natural language questions into SQL queries over increasingly complex databases. However, widely used benchmarks evaluate questions independently, overlooking settings where earlier queries over the same database can supply joins or calculations for a new question. We introduce HARE (History-AwaRe Text-to-SQL BEnchmark) to measure the accuracy and cost of adapting historical SQL. HARE comprises 1,600 requests derived from a fixed pool of 823 verified queries across four datasets. Annotations record which components each request preserves and which edits it requires, distinguishing whole-query adaptation from partial reuse. Our method, MEM-SQL (Memory-EMpowered Text-to-SQL), stores whole-query templates, reusable SQL blocks, and mappings from domain concepts to schema elements. MEM-SQL uses a layer only if every requirement assigned to it has a match above that layer's threshold. With On-demand Schema Linking (OSL), MEM-SQL consults the schema only when no layer qualifies or the generator judges retrieved evidence insufficient. Across six language models on HARE, mean execution accuracy rises from 37.1% for Direct Generation without history to 50.0% for MEM-SQL, with 76.6% fewer input tokens and 68.8% lower latency on average. Further analysis shows that requests reusing several verified queries remain a bottleneck, with accuracy falling from 56.7% to 29.7%, most sharply when reused components must be placed in a new query structure or combined with a shared join. Applying OSL to three other memory designs consistently reduces generation cost, while its accuracy benefit depends on the memory design. Verified history can thus make generation both more accurate and cheaper, but its value depends on the evidence retained and when the system consults the schema.

## Bridge: Database-Grounded Interactive Disambiguation for Text-to-SQL

DevFeed: [Bridge: Database-Grounded Interactive Disambiguation for Text-to-SQL](<https://devfeed.tech/articles/bridge-database-grounded-interactive-disambiguation-for-text-to-sql-135443.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.17770>)

Author: Sau Lai Yip, Yue Pang, Shiwen Wu, Xiaofang Zhou

Published: 2026-11-16T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>)

Tags: [about](<https://devfeed.tech/tags/about.md>), [abstract](<https://devfeed.tech/tags/abstract.md>), [alternatives](<https://devfeed.tech/tags/alternatives.md>), [arxiv](<https://devfeed.tech/tags/arxiv.md>), [based](<https://devfeed.tech/tags/based.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [bridge](<https://devfeed.tech/tags/bridge.md>), [but](<https://devfeed.tech/tags/but.md>), [challenge](<https://devfeed.tech/tags/challenge.md>), [column](<https://devfeed.tech/tags/column.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [database](<https://devfeed.tech/tags/database.md>), [detection](<https://devfeed.tech/tags/detection.md>), [dev](<https://devfeed.tech/tags/dev.md>), [effectiveness](<https://devfeed.tech/tags/effectiveness.md>), [errors](<https://devfeed.tech/tags/errors.md>), [grounded](<https://devfeed.tech/tags/grounded.md>), [interactive](<https://devfeed.tech/tags/interactive.md>), [sql](<https://devfeed.tech/tags/sql.md>), [text](<https://devfeed.tech/tags/text.md>)

### AI overview

Bridge addresses text-to-SQL ambiguity by grounding iterative clarification in database-specific offline indexes. It builds a Column Ambiguity Graph from database-grounded signals and LLM verification, then uses columns and values from an incorrect SQL prediction to retrieve alternatives from that graph and a value-similarity index for further pruning and ambiguity detection. On BIRD-dev without benchmark-provided evidence, Bridge reportedly exceeded the strongest baseline by 11.60% in execution accuracy at comparable LLM cost, with column-usage recall and precision gains of 5.25% and 12.37%. These findings are reported in the supplied abstract.

### Source excerpt

arXiv:2611.17770v1 Announce Type: new Abstract: Ambiguity remains a persistent challenge in text-to-SQL, where an underspecified natural-language question may admit multiple plausible SQL interpretations. Recent work attempts to recover the user's intended interpretation through iterative clarification, but typically relies heavily on LLM parametric knowledge for ad hoc reasoning, leading to limited ambiguity-resolution effectiveness and high LLM cost. We further observe that many ambiguity errors stem from ambiguous column grounding, which remains poorly handled. Therefore, we propose Bridge, a database-grounded disambiguation framework built on an existing iterative protocol. Bridge supplies the LLM's ambiguity detection with offline-distilled knowledge about potential ambiguity relations among columns in the target database. Offline, Bridge constructs a Column Ambiguity Graph by first identifying potentially ambiguous column pairs using complementary database-grounded signals, followed by LLM-based verification. Online, columns and values mentioned in a previous incorrect SQL prediction are used as anchors to retrieve alternatives from the Column Ambiguity Graph and an offline-constructed value similarity index, respectively. The results are integrated for further pruning and consolidated for subsequent ambiguity detection. Extensive experiments on BIRD-dev without the benchmark-provided evidence show that, at comparable LLM cost, Bridge outperforms the strongest baseline by 11.60% in execution accuracy and improves the recall and precision of column usage in the final SQL by 5.25% and 12.37%, respectively.

## DuckDB has an answer to "bloated" database messages

DevFeed: [DuckDB has an answer to "bloated" database messages](<https://devfeed.tech/articles/duckdb-has-an-answer-to-bloated-database-messages-134453.md>)

Original publisher: [Read original article](<https://thenewstack.io/duckdb-quack-database-protocol/>)

Author: Jennifer Riggins

Published: 2026-11-15T15:05:56Z

Content type: news

Language: en

Sources: [The New Stack](<https://devfeed.tech/sources/the-new-stack.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [Database](<https://devfeed.tech/topics/database.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [2-0-0](<https://devfeed.tech/tags/2-0-0.md>), [amsterdam](<https://devfeed.tech/tags/amsterdam.md>), [application](<https://devfeed.tech/tags/application.md>), [argument](<https://devfeed.tech/tags/argument.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [aws-marketplace](<https://devfeed.tech/tags/aws-marketplace.md>), [backend-development](<https://devfeed.tech/tags/backend-development.md>), [batches](<https://devfeed.tech/tags/batches.md>), [big-data](<https://devfeed.tech/tags/big-data.md>), [cli](<https://devfeed.tech/tags/cli.md>), [client](<https://devfeed.tech/tags/client.md>), [clients](<https://devfeed.tech/tags/clients.md>), [column](<https://devfeed.tech/tags/column.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [commands](<https://devfeed.tech/tags/commands.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [messages](<https://devfeed.tech/tags/messages.md>), [podcast](<https://devfeed.tech/tags/podcast.md>), [protocols](<https://devfeed.tech/tags/protocols.md>), [results](<https://devfeed.tech/tags/results.md>), [sponsor-amazon-web-services-aws](<https://devfeed.tech/tags/sponsor-amazon-web-services-aws.md>), [sponsor-aws-marketplace](<https://devfeed.tech/tags/sponsor-aws-marketplace.md>), [sponsored](<https://devfeed.tech/tags/sponsored.md>), [sponsored-podcast](<https://devfeed.tech/tags/sponsored-podcast.md>), [video](<https://devfeed.tech/tags/video.md>)

### AI overview

Quack is DuckDB's HTTP-based client/server protocol, released in DuckDB 2.0.0 LTS, designed to reduce message overhead and stream query results as columnar data. Rather than serializing rows with repeated column details or waiting for a full query to finish, it sends DuckDB data chunks as the engine produces them, so clients can consume results while execution continues. The article says this can keep memory use small. The release adds SQL CONNECT for remote servers, -serve and -connect CLI options, and concurrent client writes using DuckDB's MVCC isolation. Further server-side stability improvements were expected in patch releases.

### Source excerpt

Older database protocols were built before big data. Some still send results row by row, repeating details like column names The post DuckDB has an answer to "bloated" database messages appeared first on The New Stack.

## DuckLake 1.1 solves the absurd complexity of data lakes at AI scale

DevFeed: [DuckLake 1.1 solves the absurd complexity of data lakes at AI scale](<https://devfeed.tech/articles/ducklake-1-1-solves-the-absurd-complexity-of-data-lakes-at-ai-scale-134083.md>)

Original publisher: [Read original article](<https://thenewstack.io/ducklake-sql-lakehouse-metadata/>)

Author: Jennifer Riggins

Published: 2026-11-14T15:45:04Z

Content type: article

Language: en

Sources: [The New Stack](<https://devfeed.tech/sources/the-new-stack.md>)

Topics: [data lake](<https://devfeed.tech/topics/data-lake.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Parquet files in Amazon S3](<https://devfeed.tech/topics/parquet-files-in-amazon-s3.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>)

Tags: [2-0-0](<https://devfeed.tech/tags/2-0-0.md>), [about](<https://devfeed.tech/tags/about.md>), [acquisition](<https://devfeed.tech/tags/acquisition.md>), [advanced](<https://devfeed.tech/tags/advanced.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [aws-marketplace](<https://devfeed.tech/tags/aws-marketplace.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [data](<https://devfeed.tech/tags/data.md>), [data-lakehouse](<https://devfeed.tech/tags/data-lakehouse.md>), [data-lakes](<https://devfeed.tech/tags/data-lakes.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [ducklake](<https://devfeed.tech/tags/ducklake.md>), [files](<https://devfeed.tech/tags/files.md>), [first](<https://devfeed.tech/tags/first.md>), [lakehouse](<https://devfeed.tech/tags/lakehouse.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [podcast](<https://devfeed.tech/tags/podcast.md>), [scale](<https://devfeed.tech/tags/scale.md>), [sponsor-amazon-web-services-aws](<https://devfeed.tech/tags/sponsor-amazon-web-services-aws.md>), [sponsor-aws-marketplace](<https://devfeed.tech/tags/sponsor-aws-marketplace.md>), [sponsored](<https://devfeed.tech/tags/sponsored.md>), [sponsored-podcast](<https://devfeed.tech/tags/sponsored-podcast.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-database](<https://devfeed.tech/tags/sql-database.md>), [stack](<https://devfeed.tech/tags/stack.md>), [that-s](<https://devfeed.tech/tags/that-s.md>), [video](<https://devfeed.tech/tags/video.md>)

### AI overview

DuckLake stores lakehouse metadata in a standard SQL database catalog while leaving the data in Parquet files, so queries can identify which files to read without traversing scattered manifest files. The excerpt says DuckLake 1.1, released alongside DuckDB 2.0.0 LTS, adds more than 200 bug fixes and runs natively in DuckDB. Its described maintenance features include combining files across snapshots to reduce file counts and requests, and inlining with flushing to address small files in streaming workloads. The article presents these as ways to reduce lakehouse complexity; it does not provide benchmarks or detailed comparisons with other formats.

### Source excerpt

How much simpler could a data lakehouse get if an ordinary SQL database kept track of its files? That's the The post DuckLake 1.1 solves the absurd complexity of data lakes at AI scale appeared first on The New Stack.

## ZDI-26-993: ATEN eco DC chartDefine SQL Injection Information Disclosure Vulnerability

DevFeed: [ZDI-26-993: ATEN eco DC chartDefine SQL Injection Information Disclosure Vulnerability](<https://devfeed.tech/articles/zdi-26-993-aten-eco-dc-chartdefine-sql-injection-information-disclosure-vulnerability-133818.md>)

Original publisher: [Read original article](<http://www.zerodayinitiative.com/advisories/ZDI-26-993/>)

Published: 2026-11-13T06:00:00Z

Content type: news

Language: en

Sources: [Zero Day Initiative](<https://devfeed.tech/sources/zero-day-initiative.md>)

Topics: [Exploit](<https://devfeed.tech/topics/exploit.md>), [Vulnerabilities](<https://devfeed.tech/topics/vulnerabilities.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [sensitive data](<https://devfeed.tech/topics/sensitive-data.md>)

Tags: [sql-injection](<https://devfeed.tech/tags/sql-injection.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>)

### AI overview

An authenticated remote attacker can exploit improper validation of color references used to create charts in ATEN eco DC, where the supplied string is incorporated into SQL queries. This can disclose stored credentials and lead to further compromise. The issue is fixed in eco DC 1.2.119.

### Source excerpt

This vulnerability allows remote attackers to disclose sensitive information on affected installations of ATEN eco DC. Authentication is required to exploit this vulnerability. The ZDI has assigned a CVSS rating of 2.7. The following CVEs are assigned: CVE-2026-126965.

## SLIDERS: Evidence Synthesis with Autonomous Database Reconciliation for Systematic Reviews

DevFeed: [SLIDERS: Evidence Synthesis with Autonomous Database Reconciliation for Systematic Reviews](<https://devfeed.tech/articles/sliders-evidence-synthesis-with-autonomous-database-reconciliation-for-systematic-reviews-131904.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2604.22294>)

Author: Harshit Joshi, Priyank Shethia, Jadelynn Dao, Monica S. Lam

Published: 2026-11-13T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Artificial Intelligence](<https://devfeed.tech/sources/arxiv-artificial-intelligence.md>)

Topics: [Large Language Model](<https://devfeed.tech/topics/llm.md>), [Agentic AI](<https://devfeed.tech/topics/what-is-agentic-ai.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [search-engines](<https://devfeed.tech/topics/search-engines.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [autonomous](<https://devfeed.tech/tags/autonomous.md>), [coding-agent](<https://devfeed.tech/tags/coding-agent.md>), [context-window](<https://devfeed.tech/tags/context-window.md>), [cs-ai](<https://devfeed.tech/tags/cs-ai.md>), [cs-cl](<https://devfeed.tech/tags/cs-cl.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-reconciliation](<https://devfeed.tech/tags/database-reconciliation.md>), [embedding](<https://devfeed.tech/tags/embedding.md>), [finance](<https://devfeed.tech/tags/finance.md>), [llm](<https://devfeed.tech/tags/llm.md>), [methodology](<https://devfeed.tech/tags/methodology.md>), [reconciliation](<https://devfeed.tech/tags/reconciliation.md>), [reviews](<https://devfeed.tech/tags/reviews.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [search](<https://devfeed.tech/tags/search.md>), [sliders](<https://devfeed.tech/tags/sliders.md>), [social-sciences](<https://devfeed.tech/tags/social-sciences.md>), [sql](<https://devfeed.tech/tags/sql.md>), [synthesis](<https://devfeed.tech/tags/synthesis.md>), [tables](<https://devfeed.tech/tags/tables.md>)

### AI overview

SLIDERS builds evidence tables for systematic reviews by extracting full-text passages as evidence or provenance, then using an autonomous coding agent to write SQL that combines fragmented information, resolves inconsistencies and removes duplicate records. The abstract reports 90% accuracy on BrowseComp+ and says SLIDERS outperformed all baselines on other benchmarks within the LLM's context window. On the larger WikiCeleb100 (3.9M tokens) and FinQ100 (36M tokens) benchmarks, it answered 78.9% and 55.2% of all questions correctly, respectively, including follow-up questions despite synthesizing evidence from only the original research question.

### Source excerpt

arXiv:2604.22294v3 Announce Type: replace-cross Abstract: Systematic reviews requires comprehensive evidence synthesis from large document corpora to answer targeted research questions and are foundational in finance, social sciences, and other technical fields. Manual construction of evidence tables is labor-intensive, and recent LLM-based assistants relying on embedding or keyword search often fail to meet the coverage standards of systematic reviews. We introduce SLIDERS, a novel LLM-based methodology for automatically assembling evidence tables tailored to research questions for systematic reviews. SLIDERS extracts full-text excerpts that serve as direct evidence or as provenance for structured data. Core to SLIDERS is an autonomous evidence reconciliation coding agent that iteratively writes SQL to analyze and reconcile extracted evidence, bringing together information fragmented across documents, resolving inconsistencies and removing duplicates across records. We evaluate SLIDERS on BrowseComp+, achieving 90% accuracy, and show that it outperforms all baselines on additional benchmarks within the LLM's context window. To assess scalability, we introduce two new evidence-synthesis benchmarks, WikiCeleb100 (3.9M tokens) and FinQ100 (36M tokens), which include follow-up questions beyond the original research query. Although SLIDERS synthesizes evidence knowing only the original question, it answers 78.9% and 55.2% of all questions correctly on WikiCeleb100 and FinQ100, respectively

## STRATOS: Bridging the Symbolic-to-Numeric Gap in Spatio-Temporal Text-to-SQL for Meteorological Data

DevFeed: [STRATOS: Bridging the Symbolic-to-Numeric Gap in Spatio-Temporal Text-to-SQL for Meteorological Data](<https://devfeed.tech/articles/stratos-bridging-the-symbolic-to-numeric-gap-in-spatio-temporal-text-to-sql-for-meteorological-data-131944.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2607.03501>)

Author: Yi Zhang, Farhad Nooralahzadeh, Jonathan F\\"urst, Fabio Scherrer, Claude Lehmann, Antonis Bezes, Vassiliki Kotroni, Kurt Stockinger

Published: 2026-11-13T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Artificial Intelligence](<https://devfeed.tech/sources/arxiv-artificial-intelligence.md>), [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [geospatial](<https://devfeed.tech/topics/geospatial.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Dataset development](<https://devfeed.tech/topics/dataset-development.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [climate](<https://devfeed.tech/tags/climate.md>), [cs-ai](<https://devfeed.tech/tags/cs-ai.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [cs-ma](<https://devfeed.tech/tags/cs-ma.md>), [data](<https://devfeed.tech/tags/data.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [dimensions](<https://devfeed.tech/tags/dimensions.md>), [execution](<https://devfeed.tech/tags/execution.md>), [exploration](<https://devfeed.tech/tags/exploration.md>), [external](<https://devfeed.tech/tags/external.md>), [framework](<https://devfeed.tech/tags/framework.md>), [knowledge](<https://devfeed.tech/tags/knowledge.md>), [mapping](<https://devfeed.tech/tags/mapping.md>), [ontology](<https://devfeed.tech/tags/ontology.md>), [query](<https://devfeed.tech/tags/query.md>), [real-world](<https://devfeed.tech/tags/real-world.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [semantic](<https://devfeed.tech/tags/semantic.md>), [spatial](<https://devfeed.tech/tags/spatial.md>), [sql](<https://devfeed.tech/tags/sql.md>), [temporal](<https://devfeed.tech/tags/temporal.md>), [text](<https://devfeed.tech/tags/text.md>)

### AI overview

STRATOS aims to make meteorological datasets more accessible through natural-language Text-to-SQL by resolving spatial and semantic ambiguities before SQL generation. Its resolution agent maps fuzzy concepts to a localized ontology and uses external knowledge bases to resolve spatial entities; a complexity-aware query rewriter changes expensive spatial predicates, with the abstract reporting execution times reduced from hours to seconds. The authors also introduce a domain-expert workload of 7,520 complex query pairs to evaluate scalability and symbolic-to-numeric translation across spatio-temporal dimensions. These are claims in the supplied abstract; it does not provide evaluation details or further evidence for the reported speedup.

### Source excerpt

arXiv:2607.03501v2 Announce Type: replace-cross Abstract: Copernicus, the European Union's Earth observation program, produces petabytes of Earth observation and climate data, offering immense potential for research, policy, and applications. However, access to these datasets requires advanced programming skills and familiarity with domain-specific formats such as NetCDF or GRIB. Moreover, general-purpose Text-to-SQL systems fail when applied naively to the meteorological domain due to a profound ``Symbolic-to-Numeric'' gap. To overcome these limitations, we present an end-to-end Text-to-SQL framework specifically engineered for real-world, scalable meteorological data exploration. Our system intercepts natural language to resolve spatial and semantic ambiguities \textit{before} SQL generation. We design STRATOS, a Spatio-Temporal Resolution Agent for Text-to-SQL to dynamically bridge the symbolic-to-numeric gap by mapping fuzzy concepts to a localized ontology and resolving spatial entities via external knowledge bases. Further, our complexity-aware query rewriter rewrites expensive spatial predicates, reducing execution times from hours to seconds. Last, we introduce the STRATOS Evaluation Workload, comprising 7,520 complex query pairs explicitly designed by domain experts to test scalability and symbolic-to-numeric translation across challenging spatio-temporal dimensions previously unexplored by Text-to-SQL systems.

## FlinkEval: A Synthetic Corpus for Evaluating Natural Language Interfaces to Streaming SQL

DevFeed: [FlinkEval: A Synthetic Corpus for Evaluating Natural Language Interfaces to Streaming SQL](<https://devfeed.tech/articles/flinkeval-a-synthetic-corpus-for-evaluating-natural-language-interfaces-to-streaming-sql-132705.md>)

Original publisher: [Read original article](<https://arxiv.org/abs/2611.17093>)

Author: Alfio Massimiliano Gliozzo, Nandana Mihindukulasooriya, Gaetano Rossiello, Erick Lee, Lisa Amini

Published: 2026-11-13T05:00:00Z

Content type: article

Language: en

Sources: [arXiv: Databases](<https://devfeed.tech/sources/arxiv-databases.md>)

Topics: [text2sql](<https://devfeed.tech/topics/text2sql.md>), [LLM evaluation / benchmarking](<https://devfeed.tech/topics/llm-evaluation-benchmarking.md>), [Apache Flink](<https://devfeed.tech/topics/apache-flink.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Confluent Cloud](<https://devfeed.tech/topics/confluent-cloud.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [annotations](<https://devfeed.tech/tags/annotations.md>), [apache-flink](<https://devfeed.tech/tags/apache-flink.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [bounded](<https://devfeed.tech/tags/bounded.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [composition](<https://devfeed.tech/tags/composition.md>), [confluent](<https://devfeed.tech/tags/confluent.md>), [confluent-cloud](<https://devfeed.tech/tags/confluent-cloud.md>), [cs-db](<https://devfeed.tech/tags/cs-db.md>), [data](<https://devfeed.tech/tags/data.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [domains](<https://devfeed.tech/tags/domains.md>), [evaluations](<https://devfeed.tech/tags/evaluations.md>), [execution](<https://devfeed.tech/tags/execution.md>), [interfaces](<https://devfeed.tech/tags/interfaces.md>), [natural-language](<https://devfeed.tech/tags/natural-language.md>), [sql](<https://devfeed.tech/tags/sql.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [synthetic](<https://devfeed.tech/tags/synthetic.md>)

### AI overview

FlinkEval provides 3,903 execution-grounded question-SQL pairs for evaluating natural-language interfaces to streaming SQL across 45 industry domains and 45 semantic labels. Its schemas and temporally consistent data are generated and validated iteratively; patterns from human-written pairs and vendor documentation guide quota-balanced generation, with reference queries executed and repaired on Confluent Cloud Apache Flink. The corpus covers windowing, temporal joins, pattern matching, nested types, and data manipulation, and pairs schema-explicit requests with business-language versions. A seven-level Question Specification Ladder tests reformulations and underspecified requests supplemented with oracle-derived clues. Baselines combine execution results with adjudicated LLM judgments and identify difficulties in composing patterns and specifying requests.

### Source excerpt

arXiv:2611.17093v1 Announce Type: new Abstract: Existing natural-language-to-SQL benchmarks primarily evaluate queries over bounded relational data, leaving streaming semantics underexplored. We introduce FlinkEval, an execution-grounded synthetic benchmark comprising 3,903 question--SQL pairs across 45 industry domains and 45 semantic labels. We create diverse schemas and domain-plausible, temporally consistent data through iterative generation and validation. SQL patterns collected from the human-written NL2SQL pairs and vendor documentation drive quota-balanced generation, and execution with a repair loop on Confluent Cloud Apache Flink produces reference queries covering windowing, temporal joins, pattern matching, nested types, and data manipulation. The corpus includes paired schema-explicit and business-language requests, with annotations for analysis by query pattern, complexity, and execution mode. A seven-level Question Specification Ladder examines semantics-preserving reformulation and underspecified requests augmented with oracle-derived clues. Baseline evaluations combine execution outcomes with adjudicated LLM judgments, revealing challenges in pattern composition and request specification.

## CVE-2026-126196 - pgEdge Postgres MCP Server read-only mode can be bypassed by SQL statement smuggling through query\_database

DevFeed: [CVE-2026-126196 - pgEdge Postgres MCP Server read-only mode can be bypassed by SQL statement smuggling through query\_database](<https://devfeed.tech/articles/cve-2026-126196-pgedge-postgres-mcp-server-read-only-mode-can-be-bypassed-by-sql-statement-smuggling-through-query-database-130808.md>)

Original publisher: [Read original article](<https://cvefeed.io/vuln/detail/CVE-2026-126196>)

Author: CVEFEED.io; github.com

Published: 2026-11-12T18:17:24Z

Content type: news

Language: en

Sources: [Latest High/Critical Vulnerabilitiy Feed](<https://devfeed.tech/sources/latest-high-critical-vulnerabilitiy-feed.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [cve-2026-126196](<https://devfeed.tech/tags/cve-2026-126196.md>), [database](<https://devfeed.tech/tags/database.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [integrity](<https://devfeed.tech/tags/integrity.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [mcp-server](<https://devfeed.tech/tags/mcp-server.md>), [model-context-protocol](<https://devfeed.tech/tags/model-context-protocol.md>), [pgedge](<https://devfeed.tech/tags/pgedge.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [protocol](<https://devfeed.tech/tags/protocol.md>), [sql](<https://devfeed.tech/tags/sql.md>), [transaction](<https://devfeed.tech/tags/transaction.md>)

### AI overview

Before version 1.1.0, pgEdge Postgres MCP Server could bypass `read_only` through `query_database`: unrecognized SQL sent via pgx Exec without bind parameters used PostgreSQL's simple query protocol, which accepts multiple semicolon-separated statements. When the connecting role had write privileges, a caller could combine transaction or session changes with database writes; pooled session state could also leave later calls writable. The issue could affect integrity and availability, but the description reports no added confidentiality impact beyond permitted reads. The issue is fixed in version 1.1.0.

### Source excerpt

CVE ID :CVE-2026-126196 Published : Nov. 12, 2026, 6:17 p.m. | 1 hour, 26 minutes ago Description :pgEdge Postgres MCP Server enables SQL queries against PostgreSQL databases through Model Context Protocol compatible clients. Prior to 1.1.0, query_database on a read_only connection could send unrecognized statements through pgx Exec without bind parameters, selecting PostgreSQL's simple query protocol and allowing multiple semicolon-separated statements in one request. A caller could combine transaction or session state changes with database writes, and pooled session state could leave later calls writable, when the connecting role held write privileges. The flaw affected deployments relying on read_only as a safety boundary, could compromise integrity and availability, and did not add confidentiality impact beyond the reads already permitted by the connection. This issue is fixed in 1.1.0. Severity: 8.1 | HIGH Visit the link for more details, such as CVSS details, affected products, timeline, and more...

[Next page](<https://devfeed.tech/topics/sql.md?cursor=WyIyMDI2LTExLTEyVDE4OjE3OjI0KzAwOjAwIiwgIjkxNjFmZjdkLWZhNTItNGQ0Mi1hNjYxLTAyZWRiYjFjYmRlZiJd>)