curl --request GET \
  --url https://developer.synq.io/api/sql-insights/v1/join-patterns \
  --header 'Authorization: Bearer <token>'

import requests

url = "https://developer.synq.io/api/sql-insights/v1/join-patterns"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://developer.synq.io/api/sql-insights/v1/join-patterns', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://developer.synq.io/api/sql-insights/v1/join-patterns",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://developer.synq.io/api/sql-insights/v1/join-patterns"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.get("https://developer.synq.io/api/sql-insights/v1/join-patterns")
  .header("Authorization", "Bearer <token>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://developer.synq.io/api/sql-insights/v1/join-patterns")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "patterns": [
    {
      "key": [
        {
          "column": {
            "entityId": "<string>",
            "column": "<string>",
            "derivation": "JOIN_SIDE_DERIVATION_UNSPECIFIED",
            "expression": "<string>"
          },
          "other": {
            "entityId": "<string>",
            "column": "<string>",
            "derivation": "JOIN_SIDE_DERIVATION_UNSPECIFIED",
            "expression": "<string>"
          },
          "kind": "JOIN_KIND_UNSPECIFIED",
          "operator": "JOIN_OPERATOR_UNSPECIFIED",
          "leads": true,
          "joinType": "JOIN_TYPE_UNSPECIFIED",
          "nativeJoinType": "<string>"
        }
      ],
      "filters": [
        "<string>"
      ],
      "evidenceKinds": [
        "JOIN_EVIDENCE_KIND_UNSPECIFIED"
      ],
      "sources": [
        {
          "entityId": "<string>",
          "statementIndex": 123,
          "joinIndex": 123
        }
      ],
      "queryLog": {
        "queries": 123,
        "distinctLogins": 123,
        "firstHour": "2023-01-15T01:30:15.01Z",
        "lastHour": "2023-01-15T01:30:15.01Z",
        "issuers": [
          {
            "platform": "<string>",
            "entityId": "<string>",
            "queries": 123,
            "distinctLogins": 123,
            "kind": "JOIN_ISSUER_KIND_UNSPECIFIED"
          }
        ],
        "sampleQueryId": "<string>"
      },
      "joinTypes": [
        {
          "kind": "JOIN_KIND_UNSPECIFIED",
          "joinType": "JOIN_TYPE_UNSPECIFIED",
          "nativeJoinType": "<string>",
          "keeps": "JOIN_KEEPS_UNSPECIFIED",
          "filters": [
            "<string>"
          ],
          "sources": [
            {
              "entityId": "<string>",
              "statementIndex": 123,
              "joinIndex": 123
            }
          ],
          "queryLog": {
            "queries": 123,
            "distinctLogins": 123,
            "firstHour": "2023-01-15T01:30:15.01Z",
            "lastHour": "2023-01-15T01:30:15.01Z",
            "issuers": [
              {
                "platform": "<string>",
                "entityId": "<string>",
                "queries": 123,
                "distinctLogins": 123,
                "kind": "JOIN_ISSUER_KIND_UNSPECIFIED"
              }
            ],
            "sampleQueryId": "<string>"
          }
        }
      ]
    }
  ],
  "queryLogCoveredHours": 123,
  "queryLogLeftOut": {
    "coalesceQualityQueries": 123,
    "coalesceLogins": 123,
    "serviceAccounts": 123
  },
  "entityIds": [
    "<string>"
  ]
}