query {
  sqlV1(input: { query: """
    SELECT 
      restaurant_name,
      taco_name,
      SUM(quantity) AS total_tacos_sold,
      SUM(taco_total_price) AS total_sales,
      AVG(taco_unit_price) AS average_taco_price
    FROM 
      "TacoSoft Demo Data"
    WHERE 
      order_item_generated_at >= NOW() - INTERVAL '1 month'
    GROUP BY 
      restaurant_name, 
      taco_name
    ORDER BY 
      total_sales DESC
    LIMIT 10
  """ }) {
    columns { columnName }
    rows
  }
}

  curl -X POST https://api.us-east-2.propeldata.com/graphql \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer <Access Token>"; \
  -d '{
    "query": "query sql($input: SqlV1Input!) { sqlV1(input: $input) { columns { columnName } rows } }",
    "variables": {
      "input": {
        "query": "SELECT * FROM \"TacoSoft Demo Data\" LIMIT 3"
      }
    }
  }'

import { useSql, useAccessToken } from '@propeldata/ui-kit'

function Sql() {
  const { accessToken } = useAccessToken()
  const { data } = useSql({
    accessToken,
    query: 'SELECT * FROM "TacoSoft Demo Data" LIMIT 5'
  })
  const { columns, rows } = data?.sqlV1 ?? {}

  return (
    
        {columns?.map((col, i) => (
          
        ))}
      
      {rows?.map((row, i) => (
        
          {row?.map((col, j) => (
            
          ))}
        
      ))}
    

      
{col?.columnName}
{col}
  )
}

$ psql -h postgresql.us-east-2.propeldata.com \
       propel $PROPEL_APPLICATION_ID

propel=> SELECT restaurant_name, 
                taco_name, 
                SUM(quantity) AS total_tacos_sold, 
                SUM(taco_total_price) AS total_sales, 
                AVG(taco_unit_price) AS average_taco_price
         FROM "TacoSoft Demo Data"
         WHERE created_at >= NOW() - INTERVAL '1 month'
         GROUP BY restaurant_name, taco_name
         ORDER BY total_sales DESC
         LIMIT 3;