This gist demonstrates joining across user defined block properties. To start, paste the following 3 blocks in Logseq:
- type:: person
name:: foo
- type:: comment
author:: foo
text:: bar
- #+BEGIN_QUERY
{:title "Query joining blocks by user defined properties"