Rework `fetch_login_data()`

[bendk]

This function seems unnecessarily complex and we should simplify it. Some issues to address:

• Do we need a macro to set the local/remote logins?
• Can we create an SQL query that's less fragile and doesn't have the possibility of errors like #4667?

┆Issue is synchronized with this Jira Task