Add `where_clause` argument to macros

[dweaver33]

Description & motivation

This will allow a user to specify a WHERE clause so the user can filter out which data to profile.

Checklist

• [x] I have verified that these changes work locally on the following warehouses (Note: it's okay if you do not have access to all warehouses, this helps us understand what has been covered):
  • [ ] Postgres
  • [ ] BigQuery
  • [x] Snowflake
  • [ ] Redshift
  • [ ] SQL Server
• [x] I have written tests for new macros (either as dbt schema tests in integration_tests/models, dbt data tests in integration_tests/tests or integration tests in the CI workflow)
• [x] I have updated the README.md (if applicable)

[dweaver33]

@stumelius, first attempt. Let me know if there's any changes needed.

[stumelius]

@dweaver33 Great work, the code looks good! I left a few comments for you.

[dweaver33]

@stumelius, I think you need to mark your review as finished so I can see the comments.

[stumelius]

@dweaver33 Lol, my bad 🤦 There you go!

[dweaver33]

I only know that you have to finish the review because I've done it myself. 😅