Using the official dock, I don't have a picture until I sleep cycle* my Deck if the TV is not on before waking it up. There is no picture on either display until then.
Also I am using a tiny keyboard for waking up the Steam Deck and it never works if I replugged the device without another sleep cycle.
It's not great, but at least there are some workarounds. Which work for me.
*Sleep cycle means waking up the device and putting it back to sleep at least once
I was about to write the same thing. Really the object thing is the whole reason to use ORMs.
Using plain SQL is a compatibility and migration nightmare in medium and bigger sized projects. If anything using plain SQL is just bad software design at least in an OOP context.