chore: upgrade goreleaser to v2 (#4123) #4819

Job	Run time
Generate SDKs	3m 41s
Run tests and lints	4m 40s
Run end-to-end tests (postgres)	4m 3s
Run end-to-end tests (cockroach)	4m 40s
Run Playwright end-to-end tests (postgres)	1s
Run end-to-end tests (sqlite)	4m 5s
Run Playwright end-to-end tests (cockroach)	27s
Run end-to-end tests (mysql)	4m 15s
Run Playwright end-to-end tests (sqlite)	1s
Run Playwright end-to-end tests (mysql)	17s
Build CLI docs	1s
Generate changelog	1s
Generate release	1s
Draft newsletter	1s
Release SDKs	1s
Render version schema	1s
Pending approval Slack notification	1s
Send newsletter	1s
	26m 18s

Provide feedback