Columns that not allowed to updated

Hi guys, I'm looking for a proper way to declare SQL schema and its

InferModel

InferModel

types when there're columns that are not allowed to update programmatically.

Will there be sth like

uuid().const()

uuid().const()

text().static()

text().static()

,... for that type of columns? and then

InferModel

InferModel

will only accept updatable column.

I'm new to SQL and drizzleORM, below is my current implementation.
eg: one of that type of column is

updated_at

updated_at

on attached image 1.
I have a trigger & function to auto-update the

updated_at

updated_at

column (img 2) that execute with the migrate script.

For now, Im using

Omit

Omit

InferModel

InferModel

to remove those columns from the update & insert types. Its quite inefficient if there are many such columns tho.

No replies yetBe the first to reply to this messageJoin