Ah, I’ve never touched R packages.
I’d start by adding libtiff and sqlite to buildInputs of the sf derivation.
buildInputs
sf