MySQL is the only main used database returning Uuid as a string, so they created an additional function, uuid_to_bin, to convert the string value to binary. This is a "feature" required for https://github.com/prisma/prisma/issues/7010.
This is the clearer of all the options... Another set of ideas could be:
Adding a Literal(str) function passing anything you want to use as a function
Creating a new value type, Unquoted which is not going to be quoted as other RawValues
Adding a new Expression, literal, similar to first option but using expression directly
At the end this was the clearer, of course it has a few tradeoffs:
It does not work in MySQL 5.x (uuid_to_bin)
This applies as well for the MySQL function uuid which generates a string instead of a binary
MySQL is the only main used database returning Uuid as a string, so they created an additional function, uuid_to_bin, to convert the string value to binary. This is a "feature" required for https://github.com/prisma/prisma/issues/7010.
This is the clearer of all the options... Another set of ideas could be:
Literal(str)function passing anything you want to use as a functionUnquotedwhich is not going to be quoted as otherRawValuesExpression, literal, similar to first option but using expression directlyAt the end this was the clearer, of course it has a few tradeoffs:
This applies as well for the MySQL function
uuidwhich generates a string instead of a binary