Skip to content

Add Direct Query Function #80

@theory

Description

@theory

clickhouse_raw_query() currently collects and displays all the results of a query as a single TEXT value. Determine whether it'd be feasible to provide a similar function that takes a native ClickHouse query but maps the return values to Postgres data types and column names and displays them like table, as table-returning functions to. This similar to how JSON_TABLE works; see if we can borrow the code there to dynamically determine column names and types.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestfunctionsImprove function pushdowninterfacesExpand or improve interfaces for accessing ClickHouse

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions