@bot @meso @errante @kroner the sql statement in there is about as close to doing that as you can get with computer stuff without it becoming obnoxious in other ways

a programming language that just tries to resemble english language as much as possible is applescript: https://rosettacode.org/wiki/100_doors#AppleScript and i can tell you that in a lot of cases it's just obnoxious to write. "am i phrasing this in the exact way it needs to be phrased??"

the sql statement is kind of extra annoying because the way pleroma stores its idea of users, relationships between users, and of a relationship being a 'block' is kind of dumb, but the way it stores the ideas of posts and "a post being private" is really really really dumb so code that does "show me all of bot's private posts" would be a mess

if anything that code is unusually /readable/ because it is just "show me everyone who blocked errante" instead of something like "please open a list of all users and then retrieve the user who goes by errante and remember than and then look at each user inividually and then tell me the list of everyone that user has blocked and then check to see if errante is in that list and if errante is in that list then tell me the name of that user and then if there is a problem doing any of that then don't bother me with that information but just look at the next user, and also if that all went ok then go to the next user too"