Can I filter my data with a SQL query before validation?

Can I use a SQL query in the “row_condition” parameter in an expectations use? Is there a function where I can filter through SQL query?

You can create a data asset from a query to apply expectations to – you could also create a Custom QueryExpectation that does this filtering as a part of the metric query.