Dave,
When connecting to SQL Server via SI Web Parts, you could configure the Catalog so that the Entity/Operation/Parameter could take the parameter input from HTTP Request value.
Alternatively you could set up the filter panel and supply your input in the filter panel as parameters to call SQL Server. You need to review the help on the filter panel usage property and understand how filter values are used to filter either on the server side, or client side or both.