[CT-2502] [Bug] Wrap check constraint expression in parens

[jtcohen6]

duckdb/dbt-duckdb#156

dbt-core/core/dbt/adapters/base/impl.py

Lines 1310 to 1311 in 828d723

	if constraint.type == ConstraintType.check and constraint.expression:
	return f"check {constraint.expression}"

dbt-core/core/dbt/adapters/base/impl.py

Lines 1389 to 1390 in 828d723

	if constraint.type == ConstraintType.check and constraint.expression:
	return f"{constraint_prefix}check {constraint.expression}"

should both be

 if constraint.type == ConstraintType.check and constraint.expression: 
     return f"check ({constraint.expression})" 

Parentheses are required on:

• Postgres
• Databricks
• DuckDB

---

Also:

• Add functional tests on all our adapters for all supported constraints types

[emmyoop]

Need to add tests in core/adapters for column level and model level constraints.

Open question: do methods needs to be updated?

[emmyoop]

Do along with #7417