Issue with dynamically building condition clause

I try to build a dynamic query with dynamic filters within a transaction but does not work. It returns 0 results.

Here is my code

let dynamicFilters = [
        transactionSql`id=${id}`,
        transactionSql`name=${name}`,
    ];


await transactionSql`
SELECT * FROM table WHERE ${ dynamicFilters.join(' AND ') }
`

I also tried below but does not work either

await transactionSql`
SELECT * FROM table WHERE ${ transactionSql`${ dynamicFilters.join(' AND ') }` }
`

If I replace the expression with the actual sql string it will work

await transactionSql`
SELECT * FROM table WHERE id=${id} AND name=${name} }
`

Any idea why?

Start with the transactionSql tagged-template examples in the issue and trace how dynamicFilters is composed and interpolated. No source files or tests are identified in the report, so first locate the tagged-template entry point and existing tests for interpolated SQL fragments; done means the composition behavior is explained and covered by a reproducible test or documented usage.