Extract Schema, Table, column and Alias when alias are not always present

[KarthikATOS22]

Is it possible to extract table names and column names from tsql query as in the below format
Output format
Columns: [(Schema,Table,Column,Alias), (Schema,Table,Column,Alias)]

Example Query: SELECT O.OrderID as Col1, O.CustomerName FROM dbo.Orders as O where O.col5= 100 order by O.Odate"
Columns: [('dbo','Orders','OrderID','Col1'), (('dbo','Orders','CustomerName',None)]
Challenge is, some column may have alias and some may not.