MySQL source: loading from SQL query, not tables/views?

Don’t have control over source DB, and need to mask certain fields from being migrated.

Is there a way to load data from SQL query as a source, instead of directly from table schema?

Only using views @jcz today Airbyte doesn’t have an option to customize the query executed to pull data.