I use a "swan neck" fitting. I had mine custom made, it really makes things easy and no water intrusion is possible.
Looks like this:
The tube projects for about 1" downward from the flange, which makes it sit pretty strongly in the deck.
Looks like this:

The tube projects for about 1" downward from the flange, which makes it sit pretty strongly in the deck.