Converts a multi-line formatted SQL query into an escaped single line string for inclusion in a JSON based MML file.

fullsql2singleline-noas.sh

#!/bin/sh

# Converts a multi-line formatted SQL query into an escaped single line string
# for inclusion in a JSON based MML file.

# Reads from stdin and writes to stdout.

sed '{:q;N;s/\n/\\n/g;t q}'

fullsql2singleline.sh

#!/bin/sh

# Converts a multi-line formatted SQL query into an escaped single line string
# for inclusion in a JSON based MML file.

# It also encases the query in "( [query] ) AS [table]" as required for your
# MML's table field.

# Reads from stdin and writes to stdout.

sed '{:q;N;s/\n/\\n /g;t q}' | sed 's/^/(\\n /g' | sed 's/$/\\n) AS /g'

singleline2fullsql.sh

#!/bin/sh

# Converts a single-line SQL statement from a JSON based MML file into a
# multi-line formatted SQL query.

# Reads from stdin and writes to stdout.

sed 's/\\n/\n/g'