from digging around here, it seems like a query for human users (non machine accounts) on MacOS is:

SELECT username, directory, uid FROM users WHERE SUBSTR(uuid,1,8) != 'FFFFEEEE'

I'm wondering if this kind of check has any apple documentation (I tried looking online and didn't find much) and if it's been pretty reliable in practice.