Changelog

This file lists changes up to version 1.0.1. See https://github.com/akheron/sqltyper/releases for newer releases.

1.0.1

Enhancements

Add support for INSERT INTO ... SELECT syntax (#39)

Dependencies

Works with TypeScript >=3.8

1.0.0

Enhancements

Add support for window function syntax (#27)
Add support for SELECT DISTINCT syntax
Add support for JOIN USING syntax (#32)
Allow semicolon in the end of queries (#36)
Add support for /* */ comments (#38)
Add support for :param placeholder style (#42)

Bug fixes

Use postgres.js internally (adds support for Node 14.x)

0.2.5

Enhancements

Add support for INSERT ... ON CONFLICT ...

0.2.3

Enhancements

Emit warnings about unknown SQL functions and operators (#18)

0.2.2

Enhancements

More condensed console output (#14)
Don't write files if they're up to date (#13)
Add a comment noting that .ts files are generated (#12)
Infer parameter nullability correctly (#10)

0.2.1

Enhancements

Infer the row count of a "calculator" SELECT statement as one
Support boolean, null and float constants
Support the CASE expression

Bug fixes

Treat qualified and unqualified column as equal if the column name is the same
Param is not replaced correctly if it's used more than once

0.2.0

Enhancements

Enhance nullability infering with logical operators (AND, OR, NOT)
Add support for more functions and operators
- Comparison
- Mathimatical
- Add support for string functions with special syntax
Add --check CLI option
Better warning messages

0.1.0

Initial release