Test deployment should run with duckdb (or similar)

[ravenac95]

What is it?

In response to #1783, we need to reduce the cost test deployment. We can achieve this by running test deployments against duckdb. This would be dependent on #1456, as dbt cannot retarget to a different database immediately. This also has the added benefit of allowing users to run any models related tests locally.

[ryscheng]

@ravenac95 we're actually really close to this right?

[ravenac95]

hrmmm not for dbt, but for dagster that's a possibility

[ryscheng]

This is made obsolete by this! https://github.com/opensource-observer/oso/issues/2090