Skip to content

[Feature Request]: Add CTE support in SQLWrapper #19889

New issue
New issue
Open
#19890
Open
[Feature Request]: Add CTE support in SQLWrapper#19889
#19890
Labels
enhancementNew feature or requesttriageIssue needs to be triaged/prioritized
@sergiossm

Description

@sergiossm
sergiossm
opened on Sep 17, 2025

Feature Description

Current implementation naively replaces all FROM and JOIN clauses, which breaks CTEs since CTE names should not be schema-prefixed:

llama_index/llama-index-core/llama_index/core/utilities/sql_wrapper.py

Line 224 in fb587fe

if self._schema:

Reason

No response

Value of Feature

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesttriageIssue needs to be triaged/prioritized

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions