I won't get involved in what a DAM is, all I want is a replacement for Google Picasa.
Good features of Picasa:
Face recognition
Stores face recognition data in XMP in the jpg file (So can be read by DS photo for example - see below)
Enables placing of a location.
Not so good features
No longer supported
Requires a separate database, which has therefore to be backed up and causes problems when moving files to a new computer
Not for use on a network.
Cannot amend person details (possibly because of the link to uploaded Google photos)
I haven't used Lightroom but have DS Photo on my Synology network storage.
Good features:
Picks up face data from XMP
Free (with Synology drive!)
Has location data
Use on a network
Mobile apps available
Not so good
Must be used through a browser for all features (I think)
Not as many features as Picasa.
I would therefore hope that the release for Affinity:
Stores all data (metadata) in the file (even if a separate database is used for indexing)
Can be used on a network
Picks up data (including face recognition) from XMP data
Has face recognition facility
Good search facility
Opportunity to amend and add to metadata
Can be easily moved to a new computer, without loss of data
Good luck with the new program. Although I'm using free programs at the moment, I'd be happy to pay for a good organizer.
Incidentally, if you want to view metadata attached to a file, try Exif Pilot http://www.colorpilot.com/exif.html