_.sh

#!/bin/bash

set -e
set -o pipefail

TABLE_INFO=$(cat)
echo "${TABLE_INFO}" | jq -r .name | tr '[:upper:]' '[:lower:]' | while read x ; do printf "create table $x(" ; done
echo "${TABLE_INFO}" | jq -r '.columns | .[] | .type = if .type == "offsetdatetime" then "datetime" elif .type == "number" then "decimal" elif .type == "string" then "varchar(255)" elif .type == "boolean" then "boolean" else null end | [.column, .type] | @csv' | tr -d '"' | tr ' ' '_' | tr '[:upper:]' '[:lower:]' | tr ',' ' ' | perl -pe 'chomp if eof' | tr "\n" ","
printf ')'