Feature: add `is_logical_dtype` and average for bool column

[xtutran]

Description & motivation

• I would like to compute the avg for boolean column with assumption that (True -> 1, False -> 0, null -> 0).
• I have implemented the function is_logical_dtype in cross_db_utils.sql macros and also updated the get_profile.sql

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):
  • [ x] Postgres
  • [ x] BigQuery
  • [ ] Snowflake
  • [ ] Redshift
  • [ ] SQL Server
  • [ ] Databricks
• [ 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)
• [ ] I have updated the README.md (if applicable)

[stumelius]

@xtutran Amazing, thanks for this! The code is clean and works like a charm 💯

[xtutran]

@xtutran Amazing, thanks for this! The code is clean and works like a charm 💯

Thanks for accepting the PR and very useful package! 👍