Lucid - JOIN with inline table

[thedomeffm]

Is it possible in Lucid to write this query without rawQuery, but with join on a Lucid Model?

SELECT s.*
FROM products s
JOIN (
  VALUES
    ('Duck'),
    ('Bread'),
    ('Milk'),
    ('Btuter')
) AS terms(term)
ON s.name % terms.term
ORDER BY name

first try:

❌ This joinRaw does not work because the trimmedTerm got wrapped in single qoutes:

const trimmedTerm = names.map((name) => `('${name.trim()}')`).join(',');

Product.query()
            .joinRaw(`JOIN (VALUES ?) AS terms (term) ON product.name % terms.term`, [trimmedTerm])
            .orderBy('name');

Result:

select *
from "product"
         JOIN (VALUES '(''example'),(''foobar'')') AS terms (term)
              ON product.name % terms.term
order by "name" asc

dangerous

⚠️ This works, but i am not crazy:

Product.query()
            .joinRaw(`JOIN (VALUES ${trimmedTerm}) AS terms (term) ON product.name % terms.term`)
            .orderBy('name');

[thedomeffm]

Ok, after some help from Copilot and Gemini I got it working:

Product.query()
    .joinRaw(
        'JOIN unnest(?::text[]) AS terms(term) ON "product"."name" % terms.term',
        [names.map((name) => name.trim())],
    )
    .orderBy('name', 'asc');

[thedomeffm]

btw. it's postgres