It’s hard to say what the policies of the majors will be 5 years from now when you’re ready, but Delta’s current policy is “no DUI in the past 10 years”.
I think the structure of the pilot market is such that tightening of voluntary restrictions is unlikely.