Skip to content

engine: sqlite json_each named parameter not getting replaced with positional parameter #53

Open
@lumosminima

Description

@lumosminima

I'm using json_each to pass dynamic values in absence of sqlc.slice and have query part like following which doesn't transform properly:

-- query.sql

        AND (
            @accountTypes IS NULL
            OR at.type IN (
                SELECT value
                FROM json_each(@accountTypes)
            )
        )

-- query_sql.ts

           AND (
            ?2 IS NULL
            OR at.type IN (
                SELECT value
                FROM json_each(@accountTypes)
            )
        )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @lumosminima

        Issue actions

          `engine: sqlite` json_each named parameter not getting replaced with positional parameter · Issue #53 · sqlc-dev/sqlc-gen-typescript