I remember that! Worst character ever. He reminded me of that floating green Martian they introduced on Flintstones.
I think Star Trek: TNG Q and this Q are the same, both grounded in the same reality.