A JSON standard for SQL schemas?

Question

I'm looking for a way to define a SQL schema in JSON. It doesn't need to be comprehensive. Each column should have a data type, and I need to ability to specify "not null", "primary key", "foreign key", "unique", and "default". For now, I don't care about views, custom functions, computed properties, etc.

verdverm · Accepted Answer

Keep an eye on https://github.com/hofstadter-io/DMAI'm working on DMA this month, and using https://cuelang.org instead of JSON. There is an open PR with the latest work on it.