Multi-part table and column names and sign related fixes

Separated the commits to be reviewer friendly :).
Hope you like the changes.