chore: upgrade goreleaser to v2 #4818

Job	Run time
Generate SDKs	3m 31s
Run tests and lints	29m 7s
Run Playwright end-to-end tests (postgres)	5m 42s
Run end-to-end tests (postgres)	45m 51s
Run Playwright end-to-end tests (cockroach)	6m 2s
Run end-to-end tests (cockroach)	49m 22s
Run Playwright end-to-end tests (sqlite)	5m 46s
Run Playwright end-to-end tests (mysql)	5m 54s
Run end-to-end tests (sqlite)	46m 35s
Run end-to-end tests (mysql)	45m 28s
Build CLI docs	1m 11s
Generate changelog	0s
Generate release	0s
Draft newsletter	0s
Render version schema	0s
Release SDKs	0s
Send newsletter	0s
Pending approval Slack notification	0s
	4h 4m 29s

Provide feedback