@errante @bot @kroner yeah, and it's very specific. Pleroma doesn't have a database of its own it uses a general-purpose database where you can store anything. probably the naming is the only confusing thing - tables, rows, etc. you store rows which have multiple columns in them inside tables.

SQL is actually one of the most human-like languages in programming. you literally query the database to "select bot FROM users" for example to fetch the bot user.

the SQL query there is actually a bit complicated, but that's because you have to learn the language to understand what it does. I don't, but from what I can tell it selects u.nickname and uu.nickname (the nickname of u and uu, the dot is to fetch that from them) from the user_relationships table. then it does some stuff to select specifically the block relationship type (which is "1" i think)