To (partially) answer my own
question from yesterday: in the data dumps, the users table includes a column for the network profile ID. So, one could download the data from multiple sites, load it into a database, and join on that (if my rudimentary DB clues are correctly applied), and from there one could do cross-site user-based queries. I think. I don't think SEDE does this though.