Hi, We want to use SQLDelight and have a use case...

# squarelibraries

[Bas de Groot]

Hi,

We want to use SQLDelight and have a use case where our queries use environment-specific table name prefixes. For example, $someEnv or $someOtherEnv, as shown below:

SELECT
    ...
FROM
    $someEnv.some_table td ON td.transaction_dossier_id = cs.transaction_dossier_id
        JOIN
    $someOtherEnv.some_other_table mc_go ON rv.grid_operator = mc_go.mtc_ean

How can we best support this behavior in SQLDelight? Is there a way to dynamically parameterize or pass these prefixes at runtime? Any guidance or workarounds would be greatly appreciated.