fix: rename [on tier] clause of create table

Summarize the changes

Rename [on tier("tier_name")] clause of create table to [in tier "tier_name"]

Ensure that

• New code is covered by unit and integration tests. In picodata follow-up --- picodata!1152 (merged)
• Related to #703 (closed)
• Public modules are documented (check the rendered version with cargo doc --open).
• (if PEST grammar is changed) EBNF grammar reflects these changes (check the result with railroad diagram generator.

Next steps

• Cherry-pick to: none
• Update sbroad submodule in picodata/picodata.
• (if EBNF grammar is changed) docs#306 (closed)

doc/sql/query.ebnf

@@ -147,7 +147,7 @@ create_table   ::= 'CREATE' 'TABLE' table
                        (',' 'PRIMARY' 'KEY' '(' column (',' column)* ')')?
                    ')'
                    ('USING' ('MEMTX' | 'VINYL'))?
-                   ('DISTRIBUTED' (('BY' '(' column (',' column)*  ')' ('ON' 'TIER' '(' tier ')')?) | 'GLOBALLY'))
+                   ('DISTRIBUTED' (('BY' '(' column (',' column)*  ')' ('IN' 'TIER' tier)?) | 'GLOBALLY'))
 create_user    ::= 'CREATE' 'USER' user 'WITH'? 'PASSWORD' "'" password "'"
                    ('USING' ('CHAP-SHA1' | 'LDAP' | 'MD5'))?
 alter_user     ::= 'ALTER' 'USER' user