SILVERCODERS SqlUnify 1.0 Beta 1

SILVERCODERS SqlUnify project can convert PostgreSQL queries to other dialects (MySQL, FirebirdSQL, MSSQL, Oracle...)!
SILVERCODERS SqlUnify
  1 Screenshot
SILVERCODERS SqlUnify project can convert PostgreSQL queries to other dialects (MySQL, FirebirdSQL, MSSQL, Oracle...)! No more problems with supporting different SQL servers in your application!

The library is available only as binary packages or as a web-based technology preview. Source code will be available soon (or now on special request). SqlUnify is not supporting subqueries and table-definition queries now but it will support it in next versions.

Here are some key features of "SILVERCODERS SqlUnify":

· SELECT without UNIONs
· INSERT
· UPDATE
· DELETE
· comments

MySQL transformations

TRUE
1
FALSE
0
UNKNOW
NULL
SELECT * FROM table LIMIT 20 OFFSET 10
SELECT * FROM table LIMIT 10,20
SELECT * FROM table OFFSET 10
FAIL
SELECT * FROM table LIMIT 10,-1
INTERVAL "1 day"
INTERVAL 1 day
INTERVAL "2 days"
INTERVAL 2 day
INTERVAL "2 days 1 hour 15 minutes"
INTERVAL 2 day + INTERVAL 1 hour + INTERVAL 15 minute
expression::type
CASE(expression AS type)
CAST(expression AS INT2)
CAST(expression AS INT4)
CAST(expression AS INT8)
CAST(expression AS SERIAL4)
CAST(expression AS SERIAL8)
CASE(expression AS SIGNED INTEGER)
expression::BOOL
CASE(expression AS UNSIGNED INTEGER)
CAST(expression AS VARCHAR)
CAST(expression AS CAHR)
CAST(expression AS TEXT)
CASE(expression AS BINARY)
CAST(expression AS TIMEZ)
CASE(expression AS TIME)
CAST(expression AS TIMESTAMP)
CAST(expression AS TIMESTAMPZ)
CASE(expression AS DATETIME)
SELECT boolean_expression FROM table
SELECT IF(boolean_expression IS NULL, 'UNKNOW', IF(boolean_expression, 'TRUE', 'FALSE'))
SELECT '2005-01-01'::DATETIME AT TIMEZONE '+01:00'
FAIL
INSERT INTO table VALUES(DEFAULT
FAIL
INSERT INTO table (field) VALUES(DEFAULT)
INSERT INTO table (field) VALUES(DEFAULT(field))
SELECT "field" FROM "table"
SELECT `field` FROM `table`
SELECT |/a FROM table
SELECT SQRT(a) FROM table
SELECT ||/a FROM table
SELECT POWER(a, 1/3) FROM table
SELECT a ^ b FROM table
SELECT POWER(a, b) FROM table
SELECT @a FROM table
SELECT ABS(a) FROM table
SELECT a IS TRUE FROM table
SELECT IF(a IS NULL, 0, a != 0) FROM table
SELECT a IS FALSE FROM table
SELECT IF(a IS NULL, 0, a = 0) FROM table
SELECT a IS UNKOW FROM table
SELECT a IS NULL FROM table
SELECT a IS NOT TRUE FROM table
SELECT IF(a IS NULL, 1, a = 0) FROM table
SELECT a IS NOT FALSE FROM table
SELECT IF(a IS NULL, 1, a != 0) FROM table
SELECT a IS NOT UNKOW FROM table
SELECT a IS NOT NULL FROM table
SELECT a IS DISTINCT FROM b FROM table
SELECT IF(a IS NULL, IF(b IS NULL, 0, 1), IF(b IS NULL, 1, a != b)) FROM table
SELECT a # b FROM table
SELECT a ^ b FROM table
SELECT ~a FROM table
SELECT ~(~(~(a) - 1)) FROM table
SELECT a || b FROM table
SELECT CONCAT(a, b) FROM table
SELECT a LIKE b FROM table
SELECT a LIKE BINARY b FROM table
SELECT a ~~ b FROM table
SELECT a LIKE BINARY b FROM table
SELECT a NOT LIKE b FROM table
SELECT a NOT LIKE BINARY b FROM table
SELECT a !~~ b FROM table
SELECT a NOT LIKE BINARY b FROM table
SELECT a ILIKE b FROM table
SELECT a LIKE b FROM table
SELECT a ~~* b FROM table
SELECT a LIKE b FROM table
SELECT a NOT ILIKE b FROM table
SELECT a NOT LIKE b FROM table
SELECT a !~~* b FROM table
SELECT a NOT LIKE b FROM table
SELECT a SIMILAR TO b FROM table
FAIL
SELECT a NOT SIMILAR TO b FROM table
FAIL
SELECT a ~ b FROM table
SELECT BINARY(a) REGEXP b FROM table
SELECT a ~* b FROM table
SELECT a REGEXP b FROM table
SELECT a !~ b FROM table
SELECT NOT (BINARY(a) REGEXP b ) FROM table
SELECT a !~* b FROM table
SELECT NOT(a REGEXP b) FROM table
SELECT date + integer FROM table
SELECT date + INTERVAL integer DAY FROM talbe
SELECT date + time FROM table
SELECT ADDTIME(date, time) FROM table
SELECT time + date FROM table
SELECT ADDTIME(date, time) FROM table
SELECT interval + interval FROM table
FAIL
SELECT time + interval FROM table
FAIL
SELECT interval + time FROM table
FAIL
SELECT date - date FROM table
SELECT TO_DAYS(date) - TO_DAYS(date)
SELECT time - time FROM table
FAIL
SELECT date - integer FROM table
SELECT date - INTERVAL integer DAY FROM talbe
SELECT interval - interval FROM table
FAIL
SELECT time - interval FROM table
FAIL
SELECT interval - time FROM table
FAIL
SELECT timestamp - timestamp FROM table
FAIL
SELECT -INTERVAL "1 day" FROM table
SELECT INTERVAL -1 DAY FROM table
SELECT interval * float FROM table
FAIL
SELECT interval / float FROM table
FAIL
SELECT (date1, date2) OVERLAPS (date3, date4) FROM table
SELECT (NOT((date4 < date1) OR (date3 > date2))) FROM table
SELECT (date1, interval1) OVERLAPS (date2, interval2) FROM table
SELECT (NOT((date2 + interval2 < date1) OR (date2 > date1 + interval1))) FROM table
SELECT CBRT(a) FROM table
SELECT POWER(a, 1/3) FROM table
SELECT LOG(a) FROM table
SELECT LOG(10, a) FROM table
SELECT RANDOM()
SELECT RAND()
SELECT SETSEED()
FAIL
SELECT TRUNC(a) FROM table
SELECT TRUNCATE(a, 0) FROM talbe
SELECT WIDTH_BUCKET()
FAIL
SELECT CONVERT()
FAIL
SELECT OVERLAY(expression1 PLACING expression2 FROM expression3 FOR expression4 FROM table
SELECT CONCAT(SUBSTR(expression1, 1, expression3 - 1), expression2, SUBSTR(expression1, expression3 + expression4)) FROM table
SELECT OVERLAY(expression1 PLACING expression2 FOR expression4) FROM table
FAIL
SELECT OVERLAY(expression1 PLACING expression2 FROM expression3) FROM table
FAIL
SELECT OVERLAY(expression1 PLACING expression2) FROM table
FAIL
SUBSTRING with regular expression
FAIL
SELECT CHR(a) FROM table
SELECT CHAR(a) FROM talbe
SELECT DECODE()
FAIL
SELECT ENCODE()
FAIL
SELECT INITCAP()
FAIL
SELECT LTRIM(string, ' ') FROM table
SELECT LTRIM(string) FROM table
SELECT LTRIM(string, char) FROM table
SELECT TRIM(LEADING char FROM string) FROM table
SELECT LTRIM(string, string)
FAIL
SELECT PG_CLIENT_ENCODING()
FAIL
SELECT QUOTE_IDENT()
FAIL
SELECT QUOTE_LITERAL()
FAIL
SELECT RTRIM(string, string)
FAIL
SELECT RTRIM(string, ' ') FROM table
SELECT RTRIM(string) FROM table
SELECT RTRIM(string, char) FROM table
SELECT TRIM(TRAILING char FROM string) FROM table
SELECT RTRIM(string, string)
FAIL
SELECT SPLIT_PART()
FAIL
SELECT STRPOS(string1, string2) FROM table
SELECT POSITION(string2 IN string1) FROM table
SELECT TO_ASCII()
FAIL
SELECT TO_HEX()
FAIL
SELECT TRANSLATE()
FAIL
SELECT AGE()
FAIL
SELECT DATE_PART("CENTURY", date) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM date) + 99) / 100) FROM table
SELECT DATE_PART("CENTURY", interval) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' interval - INTERVAL 1 month - INTERRVAL 1 day) + 99) / 100) FROM table
SELECT DATE_PART("DAY", date) FROM table
SELECT DAYOFMONTH(date) FROM table
SELECT DATE_PART("DAY", interval) FROM table
SELECT DAYOFMONTH('0000-01-01 00:00:00' + interval) FROM table
SELECT DATE_PART("DECADE", date) FROM table
SELECT FLOOR(EXTRACT(YEAR FROM date) / 10) FROM table
SELECT DATE_PART("DECADE", interval) FROM table
SELECT FLOOR(EXTRACT(YAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM table
SELECT DATE_PART("DOW", date) FROM table
SELECT (DAYOFWEEK(date) -1) FROM table
SELECT DATE_PART("DOW", interval) FROM table
FAIL
SELECT DATE_PART("DOY", date) FROM table
SELECT DAYOFYEAR(date) FROM table
SELECT DATE_PART("DOY", interval) FROM table
FAIL
SELECT DATE_PART("EPOCH", date) FROM table
SELECT UNIX_TIMESTAMP(date) FROM table
SELECT DATE_PART("EPOCH", interval) FROM table
SELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + interval) FROM table
SELECT DATE_PART("HOUR", date) FROM table
SELECT HOUR(date) FROM table
SELECT DATE_PART("HOUR", interval) FROM table
SELECT HOUR('0000-01-01 00:00:00' + interval) FROM table
SELECT DATE_PART("MICROSECONDS", date) FROM table
SELECT (MICROSECOND(date) + 1000000 * SECOND(date)) FROM table
SELECT DATE_PART("MICROSECONDS", interval) FROM table
SELECT (MICROSECOND('0000-01-01 00:00:00' + interval) + 1000000 * SECOND('000-01-01 00:00:00' + interval)) FROM table
SELECT DATE_PART("MILLENIUM", date) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM date) + 999) / 1000) FROM table
SELECT DATE_PART("MILLENIUM", interval) FROM table
SELECT FLOOR((EXTRACt(YEAR FROM '0000-01-01 00:00:00') + 999) / 1000) FROM table
SELECT DATE_PART("MILISECONDS", date) FROM table
SELECT (FLOOR(MICROSECONDS(date)) / 1000 + 1000 * SECOND(date)) FROM table
SELECT DATE_PART("MILISECONDS", interval) FROM table
SELECT (FLOOR(MILISECONDS('0000-01-01 00:00:00' + interval)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + interval)) FROM table
SELECT DATE_PART("MINUTE", date) FROM table
SELECT MINUTE(date) FROM table
SELECT DATE_PART("MINUTE", interval) FROM table
SELECT MINUTE('0000-01-01 00:00:00' + interval) FROM table
SELECT DATE_PART("MONTH", date) FROM table
SELECT MONTH(date) FROM table
SELECT DATE_PART("MONTH", interval) FROM table
SELECT (MONTH('0000-01-01 00:00:00' + interval) - 1) FROM table
SELECT DATE_PART("QUARTER", date) FROM table
SELECT FLOOR((MONTH(date) - 2 / 3)) FROM table
SELECT DATE_PART("QUARTER", interval) FROM table
SELECT FLOOR((MONTH('0000-01-01 00:00:00' + interval) - 1) / 3) FROM table
SELECT DATE_PART("SECOND", date) FROM table
SELECT (SECOND(date) + MICROSECOND(date) / 1000000) FROM table
SELECT DATE_PART("SECOND", interval) FROM table
SELECT (SECOND('0000-01-01 00:00:00' + interval) + MICROSECOND('0000-01-01 00:00:00' + interval) / 1000000) FROM table
SELECT DATE_PART("WEEK", date) FROM table
SELECT WEEK(date, 7) FROM table
SELECT DATE_PART("WEEK", interval) FROM table
FAIL
SELECT DATE_PART("YEAR", date) FROM table
SELECT YEAR(date) FROM table
SELECT DATE_PART("YEAR", interval) FROM table
SELECT YEAR('0000-01-01' + interval - INTERVAL 1 month - INTERVAL 1 day) FROM table
SELECT EXTRACT("CENTURY", date) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM date) + 99) / 100) FROM table
SELECT EXTRACT("CENTURY", interval) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERRVAL 1 day) + 99) / 100) FROM table
SELECT EXTRACT(DAY FROM date) FROM table
SELECT DAYOFMONTH(date) FROM table
SELECT EXTRACT(DAY FROM interval) FROM table
SELECT DAYOFMONTH('0000-01-01 00:00:00' + interval) FROM table
SELECT EXTRACT(DECADE FROM date) FROM table
SELECT FLOOR(EXTRACT(YEAR FROM date) / 10) FROM table
SELECT EXTRACT(DECADE FROM interval) FROM table
SELECT FLOOR(EXTRACT(YAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM table
SELECT EXTRACT(DOW FROM date) FROM table
SELECT (DAYOFWEEK(date) -1) FROM table
SELECT EXTRACT(DOW FROM interval) FROM table
FAIL
SELECT EXTRACT(DOY FROM date) FROM table
SELECT DAYOFYEAR(date) FROM table
SELECT EXTRACT(DOY FROM interval) FROM table
FAIL
SELECT EXTRACT(EPOCH FROM date) FROM table
SELECT UNIX_TIMESTAMP(date) FROM table
SELECT EXTRACT(EPOCH FROM interval) FROM table
SELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + interval) FROM table
SELECT EXTRACT(HOUR FROM date) FROM table
SELECT HOUR(date) FROM table
SELECT EXTRACT(HOUR FROM interval) FROM table
SELECT HOUR('0000-01-01 00:00:00' + interval) FROM table
SELECT EXTRACT(MICROSECONDS FROM date) FROM table
SELECT (MICROSECOND(date) + 1000000 * SECOND(date)) FROM table
SELECT EXTRACT(MICROSECONDS FROM interval) FROM table
SELECT (MICROSECOND('0000-01-01 00:00:00' + interval) + 1000000 * SECOND('000-01-01 00:00:00' + interval)) FROM table
SELECT EXTRACT(MILLENIUM FROM date) FROM table
SELECT FLOOR((EXTRACT(YEAR FROM date) + 999) / 1000) FROM table
SELECT EXTRACT(MILLENIUM FROM interval) FROM table
SELECT FLOOR((EXTRACY(YEAR FROM '0000-01-01 00:00:00' + FROM table
SELECT EXTRACT(MILISECONDS FROM date) FROM table
SELECT (FLOOR(MILISECONDS(date)) / 1000 + 1000 * SECOND(date)) FROM table
SELECT EXTRACT(MILISECONDS FROM interval) FROM table
SELECT (FLOOR(MILISECONDS('0000-01-01 00:00:00' + interval)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + interval)) FROM table
SELECT EXTRACT(MINUTE FROM date) FROM table
SELECT MINUTE(date) FROM table
SELECT EXTRACT(MINUTE FROM interval) FROM table
SELECT MINUTE('0000-01-01 00:00:00' + interval) FROM table
SELECT EXTRACT(MONTH FROM date) FROM table
SELECT MONTH(date) FROM table
SELECT EXTRACT(MONTH FROM interval) FROM table
SELECT (MONTH('0000-01-01 00:00:00' + interval) - 1) FROM table
SELECT EXTRACT(QUARTER FROM date) FROM table
SELECT FLOOR((MONTH(date) - 2 / 3)) FROM table
SELECT EXTRACT(QUARTER FROM interval) FROM table
SELECT FLOOR((MONTH('0000-01-01 00:00:00' + interval) - 1) / 3) FROM table
SELECT EXTRACT(SECOND FROM date) FROM table
SELECT (SECOND(date) + MICROSECOND(date) / 1000000) FROM table
SELECT EXTRACT(SECOND FROM interval) FROM table
SELECT (SECOND('0000-01-01 00:00:00' + interval) + MICROSECOND('0000-01-01 00:00:00' + interval) / 1000000) FROM table
SELECT EXTRACT(WEEK FROM date) FROM table
SELECT WEEK(date, 7) FROM table
SELECT EXTRACT(WEEK FROM interval) FROM table
FAIL
SELECT EXTRACT(YEAR FROM date) FROM table
SELECT YEAR(date) FROM table
SELECT EXTRACT(YEAR FROM interval) FROM table
SELECT YEAR('0000-01-01' + interval - INTERVAL 1 month - INTERVAL 1 day) FROM table
SELECT DATE_TRUNC("CENTURY", date) FROM table
FAIL
SELECT DATE_TRUNC("CENTURY", interval) FROM table
FAIL
SELECT DATE_TRUNC("DAY", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-%d 00:00:00") FROM table
SELECT DATE_TRUNC("DAY", interval) FROM table
FAIL
SELECT DATE_TRUNC("DECADE", date) FROM table
FAIL
SELECT DATE_TRUNC("DECADE", interval) FROM table
FAIL
SELECT DATE_TRUNC("HOUR", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-%d %H:00:00") FROM table
SELECT DATE_TRUNC("HOUR", interval) FROM table
FAIL
SELECT DATE_TRUNC("MICROSECONDS", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i%s.%f") FROM table
SELECT DATE_TRUNC("MICROSECONDS", interval) FROM table
FAIL
SELECT DATE_TRUNC("MILISECONDS", date) FROM table
FAIL
SELECT DATE_TRUNC("MILISECONDS", interval) FROM table
FAIL
SELECT DATE_TRUNC("MILLENNIUM", date) FROM table
FAIL
SELECT DATE_TRUNC("MILLENNIUM", interval) FROM table
FAIL
SELECT DATE_TRUNC("MINUTE", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i:00") FROM table
SELECT DATE_TRUNC("MINUTE", interval) FROM table
FAIL
SELECT DATE_TRUNC("MONTH", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-01 00;00:00") FROM table
SELECT DATE_TRUNC("MONTH", interval) FROM table
FAIL
SELECT DATE_TRUNC("SECOND", date) FROM table
SELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i:%s") FROM table
SELECT DATE_TRUNC("SECOND", interval) FROM table
FAIL
SELECT DATE_TRUNC("YEAR", date) FROM table
SELECT DATE_FORMAT(date, "%Y-01-01 00:00:00") FROM table
SELECT DATE_TRUNC("YEAR", interval) FROM table
FAIL
SELECT ISFINITE() FROM table
FAIL
SELECT TIMEOFDAY() FROM table
FAIL
SELECT TIMEZONE() FROM table
FAIL
SELECT BIT_AND(expression)
SELECT IF(COUNT(expression) = 0, NULL, BIT_AND(expression))
SELECT BIT_OR(expression)
SELECT IF(COUNT(expression) = 0, NULL, BIT_OR(expression))
SELECT BOOL_AND(expression)
SELECT IF(COUNT(expression) = 0, NULL, BIT_AND(expression != 0))
SELECT BOOL_OR(expression)
SELECT IF(COUNT(expression) = 0, NULL, BIT_OR(expression != 0))
SELECT EVERY(expression)
SELECT IF(COUNT(expression) = 0, NULL, BIT_AND(expression != 0))
SELECT TO_DATE() FROM table
FAIL
SELECT DATE_FORMAT() FROM table
FAIL
SELECT TO_TIMESTAMP() FROM table
FAIL
SELECT TO_NUMBER() FROM table
FAIL
SELECT TO_CHAR(date, '%') FROM table
SELECT DATE_FORMAT(date, '%%') FROM table
SELECT TO_CHAR(date, '"anytext %"') FROM table
SELECT DATE_FORMAT(date, 'anytext %%') FROM table
SELECT TO_CHAR(date, 'FMHH') FROM table
SELECT DATE_FORMAT(date, '%l') FROM table
SELECT TO_CHAR(date, 'HH') FROM table
SELECT DATE_FORMAT(date, '%I') FROM table
SELECT TO_CHAR(date, 'FMHH12') FROM table
SELECT DATE_FORMAT(date, '%l') FROM table
SELECT TO_CHAR(date, 'HH12') FROM table
SELECT DATE_FORMAT(date, '%I') FROM table
SELECT TO_CHAR(date, 'FMHH24') FROM table
SELECT DATE_FORMAT(date, '%k') FROM table
SELECT TO_CHAR(date, 'HH24') FROM table
SELECT DATE_FORMAT(date, '%H') FROM table
SELECT TO_CHAR(date, 'MI') FROM table
SELECT DATE_FORMAT(date, '%i') FROM table
SELECT TO_CHAR(date, 'SS') FROM table
SELECT DATE_FORMAT(date, '%s') FROM table
SELECT TO_CHAR(date, 'US') FROM table
SELECT DATE_FORMAT(date, '%f') FROM table
SELECT TO_CHAR(date, 'AM') FROM table
SELECT DATE_FORMAT(date, '%p') FROM table
SELECT TO_CHAR(date, 'PM') FROM table
SELECT DATE_FORMAT(date, '%p') FROM table
SELECT TO_CHAR(date, 'YYYY') FROM table
SELECT DATE_FORMAT(date, '%Y') FROM table
SELECT TO_CHAR(date, 'IYYY') FROM table
SELECT DATE_FORMAT(date, '%Y') FROM table
SELECT TO_CHAR(date, 'YY') FROM table
SELECT DATE_FORMAT(date, '%Y') FROM table
SELECT TO_CHAR(date, 'IY') FROM table
SELECT DATE_FORMAT(date, '%Y') FROM table
SELECT TO_CHAR(date, 'Month') FROM table
SELECT DATE_FORMAT(date, '%M') FROM table
SELECT TO_CHAR(date, 'Mon') FROM table
SELECT DATE_FORMAT(date, '%b') FROM table
SELECT TO_CHAR(date, 'FMMM') FROM table
SELECT DATE_FORMAT(date, '%c') FROM table
SELECT TO_CHAR(date, 'MM') FROM table
SELECT DATE_FORMAT(date, '%M') FROM table
SELECT TO_CHAR(date, 'Day') FROM table
SELECT DATE_FORMAT(date, '%W') FROM table
SELECT TO_CHAR(date, 'Dy') FROM table
SELECT DATE_FORMAT(date, '%a') FROM table
SELECT TO_CHAR(date, 'DDD') FROM table
SELECT DATE_FORMAT(date, '%j') FROM table
SELECT TO_CHAR(date, 'FMDD') FROM table
SELECT DATE_FORMAT(date, '%e') FROM table
SELECT TO_CHAR(date, 'DD') FROM table
SELECT DATE_FORMAT(date, '%d') FROM table

last updated on:
January 24th, 2007, 20:33 GMT
price:
FREE!
homepage:
silvercoders.com
license type:
Freeware 
developed by:
SILVERCODERS
category:
ROOT \ Database \ Database APIs
SILVERCODERS SqlUnify
Download Button

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!

Add your review!

SUBMIT