The duckdb C API and the related extension mechanism is underrated
template from which i just copy the two headers and transform a python script to bash and remove the cmake stuff !
https://github.com/duckdb/extension-template-c/tree/main
vibe coded extension for some application use https://github.com/RGenomicsETL/RBCFTools/tree/main/inst/duckdb_bcf_reader_extension






