Time for Refactor

sql-soar was ported from a Javascript project of similar functionalities a few years ago, so I can help my own company to move a large Java application platform to node. It was done in a hurry so some rough edges here and there, even though it has been running quite well in many mission critical applications I've involved.

Javascript (and node) itself has evolved quite a bit since then. The source code should be updated to keep up. So here comes the re-writes and clean up. Enjoy.

Syntax Sugar

Please refer to https://github.com/benlue/sql-soar/wiki/New-Features-of-V-1.2.3

The Stored SQL Expressions

You can store SQL expressions into files, give them quotable names and reuse them anywhere in your applications. By grouping SQL expressions in the same directory, you can quickly manage them when needed instead of peeking and poking everywhere in your application.

v1.1.7

Bug fix: when doing list query with paging, the total count will always be refreshed.

Release 1.1.6

This release is mainly for bug fixed. No new features have been introduced. For details, please refer to release notes.

Release 1.1.5

When joining tables, both syntax as "table AS alias" or "table alias" would work.

Release 1.1.4

Support the IN clause in query conditions.

Release 1.1.3

Bug fix of the runSql() method.

Release 1.1.2

Added a runSql() method to run SQL statements directly when you have to.

Release 1.1.1

Fixed a bug which would cause "date" objects unable to be written to db tables.