Actually, change %N to produce the repo identity -- the tag that is used in pkg.conf(5) -- rather than repo name: the basename of the sqlite file and the name the database is mounted as (which is properly of interest only to the inernals of pkg, and not what we want pkg query etc. to display).
Matthew Seaman