What counts as a list?

So in the database, say I have a data type user with name and email.

When I call for a list of users, I know list can only be 10,000 units long.

But in the database, does that mean I can only have 10,000 users? Or I can only work with 10,000 filtered users at a time?

No… only ‘list fields’ have a hard limit of 10,000