Bloodlines, TNG 7
Picard has a son? Ruh-roh! And an evil Ferengi is trying to kill him? Double ruh-roh! And the kid is kind’ve a punk-ass who doesn’t like learning? Oy, such troubles!
Don’t worry – it all kinda works out in the end. The kid ain’t Picard, but one wonders what contraceptive devices they use in the future.