sql: refactor the ORM tests to anchor them to cockroachdb development

[benesch]

The examples-orms job that gets run in CI is extremely flaky. There are several problems:

1. Its dependencies aren't vendored, so it's hitting public package repositories on every build.
2. It's not pinned to a particular SHA. The latest master of examples-orms is always used. This can make builds of cockroach that were fine one minute start failing the next.
3. Its tests aren't correct. There is at least one missing transaction retry loop, probably more.

We should probably just merge examples-orms into this repository.

Jira issue: CRDB-4929

[awoods187]

CC @BramGruneir and @knz I think we need to do some work on this in the current milestone. I spoke with @benesch and he said that we could make large progress with a day's worth of work or do everything needed with a week. I say let's not let perfect be the enemy of good and do the day's worth of work here to get ORM testing in place. The last thing we want is to break what ORM functioning we do have in place

[jlinder]

@rafiss I've seen you doing some work with examples orms. Is this something that's still interesting? Perhaps it's better on the AppDev board?

[rafiss]

Yeah this should be in our board. It looks like points 1 and 2 in the initial description of this issue already have been created as separate issues, independently:

• not pinned to different release branches teamcity/example-orms: example-orms isn't a pinned revision when running CI #42083
• downloading from public package repositories Example-ORMs pulls files from 3rd party vendors on every CI run, and fails if upstream is unavailable #52342 (though i'd point out that vendoring isn't really common in some of the languages tested by examples-orms, so the solution might involve creating a private package repository)

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

[jlinder]

@rafiss do you know #3 in the list is still relevant?

[rafiss]

I'm not aware of 3 being an issue any more.

[jlinder]

Great. Then we'll close this issue.