sqlizer | Java utility library for generating sql

sqlizer is a Java library. sqlizer has no bugs, it has no vulnerabilities and it has low support. However sqlizer build file is not available. You can download it from GitHub.

SQLizer is an utility library intented to be used in search applications. Given an input string it builds SQL select statement. It supports two types of inputs, numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are and, or and not. It also supports wildcards *, %, ? and _ in string searches. In case of numeric searches no wildcards are supported. To accommodate searches by strings, which have wildcards in them, backslashes \ can be used to escape appropriate characters. Obviously to search for \ it needs to be escaped as well. Strings with spaces needs to be enclosed in double quotes. The other possibility is to do a regex search, which is accomplished by enclosing string in forward slashes. The resulting SQL is targeted toward Oracle regex expressions. For example, following input strings will be appropriately evaluated. We use unions and intersects in order to accomodate searches for objects with multi-value attributes.