!rant
Question time for you very few Salesforce devs out there, yea I know there’s some.

Seeing as Google is not my friend today, I’m trying to get SOQL to return null valued fields back to a rest api, something this hunk of shit won’t do, and short of looping back through all the records and injecting these fields back in, I’m at a loss... any advise is welcome 🤯

I'm so fed up with this shit

Salesforce. Although I wasn't involved in the purchase or the implementation, I spent many 100 hour weeks dealing with the crapshoot of an implementation. A large company abused that software to the point of no return. They used that thing for everything, and then they didn't even use it right for the one thing salesforce is good at. So I guess I don't have anything against salesforce itself besides its scalability issues, custom SOQL syntax, user model, and pricing. I'm more upset about the salesforce developers/business owners that decided it was okay to use salesforce for things it was never meant for, like inventory, project management, 3rd party sales team, and so many other things that caused what should have been sub-second queries to take 30 to 60 seconds.

Has any of you worked with someone claiming he's a "Senior Software Engineer" but he does not know what he's doing? I'm not saying I'm a very good developer myself but I know how to differentiate a good code from a garbage code and architecture. It's really becoming a pain in the ass...

[Equifax Recruiter] - Hi, we have an exciting opportunity for you here at Equifax! Innovative... blah blah... J2EE... blah blah... latest technologies... blah blah... greenfield... blah... CORBA... (ok, there wasn't any CORBA)
[Me] - Oh Equifax... how did you get my details?
[ER] - ...

Don't know if it's the worst, but one that's a bit pants is SOQL, Salesforce's bastardised version of SQL. Can't alias columns in a SELECT clause, can't even compare two fields to each other in a WHERE clause.

Don't you just hate it when a git pull request assigned to you doesn't have a descriptive title and no description at all? I think I'm having a migraine! #%!%^*#