Support for column aliases (`as`)
- Langage dominant
- TypeScript
- Étoiles
- 179
- Forks
- 7
- Métriques de merge des PR
- Aucune PR mergée en 30 j
Description
Thanks for writing this library, it's exactly what I was looking for.
Is there a way to support column aliases? Here's what I get right now:
```
✖ Query validation failed in server/models/SomeModel.ts:39:13:
No table in the query's scope has a column "user_token".
Tables in scope: "some_table"
37 | export async function getUserToken(requestId: string): Promise {
38 | const { rows } = await database.query<{user_token: string}>(sql`
> 39 | SELECT details -> 'user_token' AS user_token FROM some_table WHERE
| ^
40 | request_id = ${requestId} AND
41 | details -> 'user_token' IS NOT NULL
42 | ORDER BY timestamp DESC;
```
The workaround that seems to be fine is by using `sql.raw`:
```sql
SELECT ${sql.raw('details -> \'user_token\' AS user_token')} FROM some_table WHERE
request_id = ${requestId} AND
details -> 'user_token' IS NOT NULL
ORDER BY timestamp DESC;
```
Is this the best way to handle it? Thanks!
Guide de contribution
Aucun guide de contribution indexé pour ce dépôt
Évaluation
Cette issue n'a pas encore été évaluée.