SAP's ABAP has this. You have integrated SQL and just drop a select statement. A table's type can be used seamlessly:
data products type table of comm_product. select * from comm_product into table @products.
data products type table of comm_product. select * from comm_product into table @products.
I think there is space for a programming language with first class support for typed tables. A blend of C# and SQL. F# with type providers does have some of that, or C# with linq, but in both cases, tables/relations are second-class citizen.