Enable local compile + integration testing for packages

Many packages have integration tests but they're challenging to run locally when a warehouse connection is required. We should figure out a way to enable local runs, possibly by using a local Postgres instance (although this would require work in the Postgres adapter in Fusion), a sandbox account in Snowflake, or a tool like Localstack.