This kind of approach could be a way to make these models reliable. Encode your business restrictions in the database, if they are rigorous enough, if the query passes then it's valid in your business world.
I don't think that "Google has it coming" for this. In fact I think they support the open web much more than competing alternatives (Facebook, etc) who want to create walled gardens that require auth (identity). It's up to content providers if they want to completely target SEO and create poor quality content, and some are constantly gaming the system. What Google is doing is looking for more meta content, which is a very beneficial for everyone. meta keywords didn't work, and SEO goes beyond them to provide precise information about a site's content. Anyone can use SEO techniques for good and bad, it's by no means proprietary.
It's the general Web that didn't keep up and provide better solutions for quality and precise content, solving problems like "This blog is not about avocados" or links in a sidebar about avocados that lead search results for avocados to that page. Microformats and other approaches were suggested, but they were basically too complicated and tools didn't support them.
Where Google has fallen down is not providing more search/browsing tools to allow individuals to tune sites and keywords. There are many obvious opportunities in Google search, news, etc that would make the experience amazing compared to the picking-through-the-repetitive-garbage we see today. I suspect there is a battle between their tech and marketing about this, and I also think Google's ML team are using our garbage-picking to tune their algorithms rather than letting people just choose what they want to see. That is disgraceful, and they won't change it until there is competition which makes me lose a lot of respect for Google, but I don't blame SEO directly for this and since SEO is based on standards anyone could use their own "Web reader" to add a layer of filtering without special agreements, unlike content by companies that try to create walled gardens.
It's sort of an after-install thing that takes a minute, but I have some keyboard shortcuts that allow me to do things like jump into a sketching program with the current clipboard contents. And Krita itself (and a few other good apps) are available on Linux.
Not sure how Throttlestop compares to the latest Linux options. I've got many containers going, three instances of vscode, a zillion tabs, performance is not an issue.
But, I realize not everyone cares about a free and transparent world, even when it's more and less as good. It must at least encourages companies like Microsoft to keep opening up and getting better.
Maybe I'm missing something, but font rendering seems fine on Ubuntu without any after install steps.
I've been using Ubuntu exclusively for well over a decade for everyday work, only occasionally going into a Windows VM, and it's really been perfectly fine, great even, as a developer. I bought a X1 Yoga the month after it was released and Ubuntu installed perfectly on it, the only thing that didn't work out of the box is the fingerprint reader.
Until a year ago, battery life wasn't as good as Windows/Mac, but it's very good with the latest versions.
Proprietary software that some people need to run, now that's another issue, but for most development tasks it's fantastically manageable and accessible, a real pushback against closed systems.