Queries are somewhat slowerEven when the resulting TSQL is the same, queries need more compute to prepare the TSQL. The execution time in SQL server is of course the same (which often overshadows the overhead). This is the reason we avoid converting select statements to queries in performance critical paths.
- Queries have a limited set of capabilities. For example; delete_from is not supported. Update_recordset and insert_recordset are partly supported – via some arcane static methods on SysQuery.