ahh.. tradesmen vs engineer. Never gets old.
Pipe can be threaded, flanged, brazed or welded.
Tubing can be connected with gas tubing fittings or brazed (1000+ degrees)
Flared joints are allowed in nonferrous systems.
Yes, codes are different, local AHJ blah blah blah.
Personally, threaded steel pipe is the only thing I'd use in my own home. IMHO CSST has it's uses.. and that's only where it would be impossible or impractical to install rigid steel pipe.
Pressurize to 3-5psi with a compressor or bike pump and let it sit for 10 minutes. And use a freakin 5lb gauge, not some 100psi gauge. Yeah, they're more expensive, but cheaper than burning our house down. Seen guys put 80lbs in a residential system and call it good. How the heck do you see a 1/4lb drop over 10 mins on a 100psi gauge.