Does aliasing tables names in large queries have noticeable effect on performance?
... ... FROM table_1 T1 ... ... ...
Could it be considerably different for that various DB systems available?
There a discussion about this topic already. In a nutshell, there's no significant effect on performance triggered by aliasing table names.
No. None whatsoever.