Add ability for Tables to be extended

Feature Suggestions
1

Would be cool be able to create some base table data and have your tables just extend off it so you dont have to type so much… and updating all your tables would be easy. Something like this:

TableBase standardTable {
  active boolean
  createdOn datetime
  modifiedOn datetime
}

Table user Extends standardTable {
  id int [pk]
  firstName string
  lastName string
}
2

I think using composition here would be better, but the point remains: things like metadata would be super helpful if I can define it once.

3

Update April 2025: Now you can use DBML TablePartial to define reusable sets of fields, settings, and indexes and inject them into multiple tables with a simple ~partial_name syntax.

I hope you guys like this feature.

On the other hand, you can read the reason why we don’t choose the “table inheritance” approach here.