sql placeholders always seem to get interpreted as "text"

[olee]

I have an issue regarding placeholders used in sql templates.

The issue can be reduced down to the following example query:

  const userIntId = 1;
  const testQuery = db
      .select({
          userIntId: sql<number>`${userIntId}`,
      })
      .from(sql`(select 1)`);
  console.log(pgDialect.sqlToQuery(testQuery.getSQL()));
  console.log(await testQuery.execute());

The result of this query is

[ { "userIntId": "1" } ]

even though it should be

[ { "userIntId": 1 } ]

It seems userIntId in the query is always treated as text.

Another example is this query, which will cause the postgres error operator does not exist: integer = text:

    const testQuery = db
        .select()
        .from(sql`(select 1 as "user_int_id", ${1} as "cmp")`)
        .where(eq(sql`"user_int_id"`, sql`"cmp"`));
    console.log(pgDialect.sqlToQuery(testQuery.getSQL()));
    console.log(await testQuery.execute());

In my actual query, it fails because I need to compare the int value to another one and postgres complains about operator does not exist: integer = text