Author here. Built this after writing the same D1 boilerplate across multiple Workers projects. Main idea: Kysely for type-safe query building, simple DSL for migrations, zero runtime overhead.
Leafletjs was the only oss frontend option back in 2015-2016 when we ditched Esri and created our own in-house app, based on Electron. Apart from Mapbox, which was freemium.
I hope that you do understand the difference of server provisioning and container orchestration, as mentioned above, solve completely different problems.
We do use ansible for provisioning in combination with AWS CDK. The cases are simple as when you don't utilize container services, but roll out your own server infrastructure using EC2.