Can the Command object apply any SQL query to the data source?
Yep! The Command object can be used to send just about any command to your data source. However, whether or not the command is understood is completely up to the data source. In other words, you can send an Oracle-specific command to Microsoft SQL Server, but you'll most likely receive an exception at runtime.