Only affect SQLITE (for more robust performences I recommend using MongoDB or MySQL).
Initially, I was using GENERATED COLUMN with JSON operators to do the denormalization for the indexing.
But it looks like most of minecraft servers software have a sqlite driver bellow 3.38.0 (2022-02-22).
As the sqlite driver is loaded as a native library (.dll) it's not possible to load a new one.
So I implemented the denormalization in another way. It's a bit less performant than the original solution.