Description

What component does this PR affect?

• Server
• Console
• CLI
• Docs
• Community Content
• Build System

Requires changes from other components? If yes, please mark the components:

• Server
• Console
• CLI
• Docs
• Community Content
• Build System

Related Issue

close #1040

Solution and Design

Addition distinct_on argument for GraphQL queries.

   employee (
     distinct_on: [employee_select_column]
     order_by: [employee_order_by]
   ): [employee]!

   #select column enum type for "employee" table
   enum employee_select_column {
     id
     name
     department
     salary
   }

Example query:-

      query {
        employee(
          distinct_on: [department]
          order_by: [{department: asc}, {salary: desc}]
        ){
          id
          name
          department
          salary
        }
      }

Response:-

     {
       "data": {
         "employee": [
           {
             "id": 5,
             "name": "Kamila",
             "department": "Engineering",
             "salary": 4325
           },
           {
             "id": 4,
             "name": "Damien",
             "department": "Product",
             "salary": 3124
           },
           {
             "id": 7,
             "name": "Rickard",
             "department": "Services",
             "salary": 2223
           }
         ]
       }
     }

Type

• Bug fix (non-breaking change which fixes an issue)
• New feature (non-breaking change which adds functionality)
• Breaking change (fix or feature that would cause existing functionality to change)
• Docs update
• Community content

Checklist:

• I have read the contributing guide and my code conforms to the guidelines.
• This change requires a change in the documentation.
• I have updated the documentation accordingly.
• I have added required tests.