SQLite blob data indexing / sorting?

[davecotter]

I can display blob data in a custom way quite easily: custom draw is well documented.

but how can i sort / search this blob data in a custom way?

eg: if a binary blob has "file alias data" (which is basically a file path but with extra info such that the file can be found if moved), then in the display i show the "resolved" path (easily enough), but i also want to be able to sort by how it is displayed, and search on what is displayed, not on the blob itself.

how can i accomplish this? deterministic user-function? virtual table? relational link?

any ideas? i'm open to suggestions!