I'm a bit sad this article didn't go into the life cycle of prepared queries with bound arguments at all, as that gets a lot more complicated and (given the way we should all be writing queries) is much more applicable.
It's quite interesting stuff, but because it's almost all details about the weeds a lot of abstract overviews of how DBMSes process queries skip over it as "implementation details" this particular article goes pretty deep into those details for regular queries so it'd be neat to see those details for prepared statements.