List my models on my profile page

[KevinDCarlson]

It would enhance the profile page to have it run a query to the backend resulting in listing all models associated with the active username, so that people can stop having to manually track the Automerge hashes of all their models.

[KevinDCarlson]

Here's the SQL query we'd like the front-end to make, with kevincarlson replaced by the current username and some questions about whether own is always what we want to search for. I don't know yet how you cause the front end to make such a query.

SELECT snapshots.for_ref, snapshots.content->>'name' as title
FROM snapshots
JOIN refs ON snapshots.for_ref = refs.id
JOIN permissions ON refs.id = permissions.object
JOIN users ON permissions.subject = users.id
WHERE users.username = 'kevincarlson'
AND permissions.level = 'own';