23 joins in one SQL query, aliased from a to t kill me now.

lol reminds me of a SENIOR CTO that once said a similar sentence to me

We must push graph databases!!

When people ask me if i prefer backend or frontend dev I prefer backend, but I dont necessarily enjoy doing those queries and admittedly am quite good with frontend as well.

Question:
What do you say in that situation since most queries you use as a backend dev (for me at least) are not 200+ line monsters?

Just now you get put on 'backend' dev writing that shit for the rest of your life 😋

Use an ORM(Object relation mapper)

We have a 3000 line SQL monster.. don't want to say more about it, because it gives nightmares even if i'm only talking about it 😵

3000 line query? @elzdev
What exactly are you querying?
The answer to existence ?

@m0nk the answer to existence would be way shorter IMO

(what's the shortest way to declare an empty string in sql anyway?)

If you re-arrange it you could spell out some awesomeness right there.

Generated query?

@m0nk First: it's not mine.
The coworker who wrote this, explained me as follow:
It's an analytics query over all data in our software for the bosses of our customers.

@m0nk 42