Comment by dima_vm

Not sure what you mean by "power queries", but Google Sheets support SQL queries.

Would be easier to see on an example.