Codewerk
sql transpile
Parses the query with the node-sql-parser 5.4.0 grammar of the source dialect (DuckDB input uses the PostgreSQL grammar, from which DuckDB's parser derives) and emits the target SQL with an own, allow-listed generator instead of the library's sqlify (which leaves e.g. MySQL "LIMIT 20, 10" untouched). Handled: SELECT with WITH, DISTINCT, joins, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT/OFFSET, UNION/INTERSECT/EXCEPT, subqueries, CASE, CAST/::, window functions without frames and a fixed.
POST https://code.halowerk.com/v1/sql-transpileInputs
| Field | Type | Required | Description |
|---|---|---|---|
| sql | string | Yes | One or more SELECT statements separated by semicolons. |
| from | string | Yes | Source dialect. |
| to | string | Yes | Target dialect. |
| preserve_null_order | boolean | No | Add NULLS FIRST/LAST (or the MySQL IS NULL idiom) where the default NULL ordering differs. |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"sql",
"from",
"to"
],
"properties": {
"sql": {
"type": "string",
"minLength": 6,
"maxLength": 100000,
"description": "One or more SELECT statements separated by semicolons."
},
"from": {
"type": "string",
"enum": [
"mysql",
"postgres",
"bigquery",
"snowflake",
"duckdb"
],
"description": "Source dialect."
},
"to": {
"type": "string",
"enum": [
"mysql",
"postgres",
"bigquery",
"snowflake",
"duckdb"
],
"description": "Target dialect."
},
"preserve_null_order": {
"type": "boolean",
"default": true,
"description": "Add NULLS FIRST/LAST (or the MySQL IS NULL idiom) where the default NULL ordering differs."
}
}
}Published input example
{
"from": "mysql",
"to": "postgres",
"sql": "SELECT id, name FROM users WHERE age > 18 ORDER BY name LIMIT 20, 10"
}Result & documentation
Machine-readable documentation of this hub
Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 UTC.
More endpoints in this hub
- Codewerk0.003 USDC
action sha pin
POSThttps://code.halowerk.com/v1/action-sha-pinFinds every "uses: owner/repo[/path]@ref" in a GitHub Actions workflow, resolves tags (including annotated tags) and branches to the commit SHA with git ls-remote against github.com, and rewrites the line to "uses: owner/repo[/path]@<sha> #
- Codewerk0.003 USDC
actionlint
POSThttps://code.halowerk.com/v1/actionlintRuns the official statically linked actionlint 1.7.12 release binary (MIT, SHA-256 checked against the published checksums) in an isolated child process without network, with the bundled ShellCheck 0.11.0 for run: scripts (pyflakes is not a
- Codewerk0.004 USDC
api changelog
POSThttps://code.halowerk.com/v1/api-changelogCompares operations, parameters, request bodies, response codes and media types, component schemas (one property level), servers and security schemes of two documents (Swagger 2.0 is converted with swagger2openapi first; 3.0 and 3.1 are rea