Does aliasing tables names in large queries have noticeable effect on performance?
Aliasing:

...
...
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.