Remove duplicate bookmarks from search results.

[theherk]

The bookmark search was showing duplicate entries when a URL was bookmarked multiple times. This was caused by the query returning all bookmark entries for a URL, including tag-related entries.

The fix uses a window function (ROW_NUMBER) to partition bookmarks by their foreign key (URL reference) and selects only the entry with the lowest ID for each URL. This ensures each bookmarked URL appears only once in the results while preserving all bookmark metadata including optional titles.

fixes #15442

Description

Screencast

Checklist

• [x] I read the extension guidelines
• [x] I read the documentation about publishing
• [x] I ran npm run build and tested this distribution build in Raycast
• [x] I checked that files in the assets folder are used by the extension itself
• [x] I checked that assets used by the README are placed outside of the metadata folder

[raycastbot]

Thank you for your contribution! :tada:

🔔 @Keyruu you might want to have a look.

You can use this guide to learn how to check out the Pull Request locally in order to test it.

You can expect an initial review within five business days.

[theherk]

I was also getting some db locked and read issues periodically, so I added some retry logic.

[Keyruu]

Awesome stuff man! Thanks for the contribution.

[github-actions[bot]]

Published to the Raycast Store: https://raycast.com/Keyruu/zen-browser

[raycastbot]

:tada: :tada: :tada:

We've rewarded your Raycast account with some credits. You will soon be able to exchange them for some swag.