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.

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.