Photos uses sqlite. I came across this but haven't tried them yet. https://github.com/AndrewRathbun/iOS_Photos.sqlite_Queries

There is also osxphotos for macOS.

https://github.com/RhetTbull/osxphotos