Indeed! They are usually my preferred why of interacting with the DB when the queries are complex or hold a good amount of logic. Add user-defined table types

Indeed! They are usually my preferred why of interacting with the DB when the queries are complex or hold a good amount of logic. Add user-defined table types used as parameters and you've got a good way to pass batches of data too.