How do I generate a unique id like INV0001 using exposed?

Where do you want to generate the unique value in your code or on database side?

In the database side

Then you'll need to write the custom database function, I guess and use it as a default value for a column.

What about in the code? How can I ensure uniqueness