fix: implicit transactions for cockroach v23.5 and simplified migrati… #2618

Job	Run time
Run tests and lints	12m 27s
Run HSM tests	6m 40s
Run OIDC conformity tests	9m 14s
Run end-to-end tests (memory, --jwt)	5m 47s
Run end-to-end tests (postgres)	5m 46s
Run end-to-end tests (postgres, --jwt)	5m 39s
Run end-to-end tests (mysql, --jwt)	5m 48s
Run end-to-end tests (memory)	5m 36s
Run end-to-end tests (mysql)	5m 40s
Run end-to-end tests (cockroach, --jwt)	7m 46s
Run end-to-end tests (cockroach)	7m 50s
Build CLI docs	1m 23s
Generate release	0s
Draft newsletter	0s
Pending approval Slack notification	0s
Send newsletter	0s
	1h 19m 36s

Provide feedback