Add support for handling PART and fix parsing of JOIN.