Getting full image filenames + creators from a Lightroom catalog

Lightroom filenames & creators.sql

select 
    replace(AgLibraryRootFolder.absolutePath || AgLibraryFolder.pathFromRoot || AgLibraryFile.idx_filename, '/', '\') as filename, 
    AgInternedIptcCreator.value as creator

from AgHarvestedIptcMetadata

left join AgInternedIptcCreator on AgHarvestedIptcMetadata.creatorRef=AgInternedIptcCreator.id_local
left join Adobe_images on AgHarvestedIptcMetadata.image=Adobe_images.id_local
left join AgLibraryFile on Adobe_images.rootFile=AgLibraryFile.id_local
left join AgLibraryFolder on AgLibraryFile.folder=AgLibraryFolder.id_local
left join AgLibraryRootFolder on AgLibraryFolder.rootFolder=AgLibraryRootFolder.id_local

where creator is not null
order by filename