Any way to make Dataview work with Kindle Highlights Plugin?

[Barthcbb]

I thought it'd be wild to leverage Dataview's capabilities with the Kindle Highlights Plugin to create: (1) a general database (or table) of book highlights, (2) a local base of book highlights for each book note.

So far what I've achieved looks like this: I use the Kindle Highlights Plugin to get a book note with this structure of highlights:

[loc::7234], [highlight::> test2], [note:: Note 3]

---
[loc::7258], [highlight::> test?"], [note:: Note 4]

---

And the Dataview query like this:

dataview
TABLE loc, highlight, note
FROM "Untitled"
flatten loc
SORT loc ASC

But the shortcoming is that it returns several lines with the same highlights and notes instead of one for each.

Do you know if there is a way around this or if it's even possible to achieve one highlight per row?