TypedSQL define argument type as optional/nullable

[maciejopalinski]

Your problem

https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql#defining-argument-types-in-your-sql-files

TypedSQL allows to define argument types for SQL queries.

Currently accepted types are Int, BigInt, Float, Boolean, String, DateTime, Json, Bytes, and Decimal.

It does allow to define argument type as optional or nullable.

Suggested solution

It should be possible to define argument type as optional or nullable.
Here is my suggested example:

-- @param {String | null} $1:name The name of the user

and/or

-- @param {String?} $1:name The name of the user

Alternative solutions

Right now, I am using a pretty nasty workaround to be able to use optional argument types with TypedSQL queries.

const variable: string | null;

this.db.$queryRawTyped(myTypedSqlQuery(variable as string));

Additional context

No response

[maciejopalinski]

I just figured out that it is in fact possible to define arguments as optional:

https://github.com/prisma/prisma/blob/43baa3ffe38393d7d9ae792ce751f039fcae3859/packages/client/tests/functional/typed-sql/sqlite-scalars-nullable/prisma/sql/nullableParam.sql#L1

This is not documented on the Prisma Docs regarding TypedSQL and should be mentioned there.

Thus the type of this issue should be changed from feature request to bug report (missing documentation).