Pip install on Amazon Linux 2023

[jwnimmer-tri]

Is your feature request related to a problem? Please describe.

Sometimes, users want to run pydrake inside an AWS Lambda service. Those lambda containers are based on Amazon Linux. See What is Amazon Linux 2023? for details.

Currently, this awkward / impossible because our wheels require libc >= 2.35 but AL2023 only provides libc == 2.34.

Describe the solution you'd like

Update our wheel build so that our manylinux wheels can run on public.ecr.aws/lambda/python:3.12.

Running the wheel build in a docker container with a lower libc6 baseline (so that the produced wheel has a lower baseline) will be relatively easy. The question is whether other build-dependencies like GCC or Clang or libstdc++ or etc. are sufficient, and how difficult it would be to support AL2023 wheels long term. That will require some investigation.

Describe alternatives you've considered

None.

Additional context

See AL2023 docs Improved toolchain: gcc, binutils, and glibc for a version baseline.

[jwnimmer-tri]

My plan is to finish #20731 and all of its related config flags, before any investigation starts on this issue. Having the ability to run a wheel build without any local dependencies will probably make this a lot easier.