Check constraints that depend on UDFs

[aleclarson]

Could an option be added to allow these? I realize that pg-schema-diff doesn't parse dependencies of UDFs, but my tool does, so it's not an issue. I also understand that UDF checks are somewhat of a footgun, considering they don't revalidate when changed, but I'd rather allow them than artificially limit what's possible (and I'm using a UDF check in my app!).

pg-schema-diff/pkg/diff/sql_generator.go

Lines 1847 to 1851 in 21fab6a

	// UDF's in check constraints are a bad idea. Check constraints are not re-validated
	// if the UDF changes, so it's not really a safe practice. We won't support it for now
	if len(con.DependsOnFunctions) > 0 {
	return nil, fmt.Errorf("check constraints that depend on UDFs: %w", ErrNotImplemented)
	}

[bplunkett-stripe]

Yes, we can add support for them!

[jumski]

Yes please!

I just stumbled upon this error when fiddling with Supabase's Declarative Schemas: supabase/cli#3483

migra also is unable to properly handle this :-(