standardize sql reference

standardize sql reference:

1. use the same table_identifier syntax for all the commands that use table_identifier
2. use the same view_identifier syntax for all the commands that use view_identifier
3. use the same partition_spec syntax for all the commands that use partition_spec
4. Some of the commands have a space in between of the braces and text. Some of them don't. Make it consistent to always have a space
5. remove ; from the end of the sql syntax