Revisiting the remaining syntax tests

[am357]

This issue is to track the progress for revising the remaining syntax tests to ensure they're not belong to other test categories, e.g static-analysis.

DoD

• We've documented the remaining tests in this issue from one of the implementation (E.g. partiql-lang-rust).
• Any potential PRs related to this is issue are merged.

[am357]

All the remaining test failure in partiql-lang-rust appear to be Syntax tests:

failures:
    partiql_tests::partiql_tests_data::fail::syntax::primitives::path_expression::invalid_path_component_keyword_in_path_test
    partiql_tests::partiql_tests_data::fail::syntax::query::select::select::select_query_missing_from_test
    partiql_tests::partiql_tests_data::fail::syntax::query::select::select::select_without_comma_between_projection_items_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::parameter::parameter_expression_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::parameter::select_with_parameter_and_literals_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::path_expression::pathexpr_namespace::function_call_namespace::path_with_call_nested_with_star_and_array_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_constructor_with_precision_argument_no_spaces_between_keyword_and_time_string_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_constructor_with_precision_argument_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_nano_precision_with_precision_argument_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_nano_precision_with_zero_precision_argument_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_no_space_between_keyword_and_quote_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_offset_and_precision_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_offset_precision_and_nano_seconds_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_no_space_between_keyword_and_quote_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_nano_precision_greater_than_10_and_offset_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_nano_seconds_and_precision_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_nano_seconds_precision_and_offset_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_nano_seconds_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_precision_and_no_spaces_between_precision_and_keyword_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_with_time_zone_with_precision_test
    partiql_tests::partiql_tests_data::success::syntax::primitives::time_constructor::time_without_time_zone_test