If I try to filter on two fields using an "IN", the query is rejected as having 2 sub-selects.  This just doesn't seem right, since the alternative is issuing way more queries.

For example, I can't do this:

select name, team_points from fantasysports.teams.stats
where team_key IN ('273.l.555415.t.1','273.l.555415.t.2') and stats_type='week' and stats_week IN (1,2)

even though I'm hitting only one table.

I don't think that query should be invalid.