Can SqlSyncProvider be used if you need dynamic row filtering?

Question

I need to filter rows based on the user's ID that are in the tables that I plan to syncronize from SQL Server.  I don't see how I can use a Scope to accomplish this because scopes appear to only support static filters and not allow parameters to be accessed from the FilterClause.  Is there a way to do this with the SqlSyncProvider that I am not finding?

Thanks,
David Keck