I currently use Lightroom & Lightroom Classic for organization, but I often find myself wanting to work on large numbers of files, while also being cautious about clobbering links or files. In LR Classic, I can write Lua-based scripts / plugins, which I can do, but is (for me) slow to author and worrisome about quality. And I don't at all feel like Adobe is committed to the plugin API, so I'm not even sure if it will be a future option.
With Darktable, I know I can also do Lua-based scripting.
Are there any other robust organizing tools capable of handling a >50K photo database that have a good scripting solution, either as an externally-callable API or in terms of a supported scripting language?
MacOS primarily