prisma
ResultMetadata or column size, scale, nullable enhancement
For crafting validation of fields, column or ResultMetadata should include the nullable, size, and scale attributes. This is important even if returned resultset does not contain any rows of data.
While useful in all kinds of cases, these properties are especially useful for validation, BI, ETL, and migration tools.
Nullable would be set to true on any column that allows null, and false for any column that does not allow null.
Example use cases for size and scale: for Varchar and NVarchar, size should be populated with the varchar(size), and scale would either be zero or None. for Numeric and Decimal, size should be the precision and scale should contain the number of digits to the right of the decimal. for Bitn, Intn, Floatn, Datetimen, size should be the number of bits (or bytes) of the column, and scale would either be zero or None.
If any are complex to implement, any of these attributes implemented would be helpful.
This doesn't sound bad at all. And a fun thing for write!
We're all Prisma having a company offsite next week. I have some presentations to do and fun to have. I'll be having my laptop with me and this sounds like just a perfect evening task to do for fun.
I can't promise anything for next week, but I can try...
