SILVERCODERS SqlUnify SILVERCODERS SqlUnify project can convert PostgreSQL queries to other dialects (MySQL, FirebirdSQL, MSSQL, Oracle...)!
Download

SILVERCODERS SqlUnify Ranking & Summary

SILVERCODERS SqlUnify Tags

convert convert PostgreSQL queries MySQL queries FirebirdSQL queries SILVERCODERS SqlUnify

SILVERCODERS SqlUnify Description

SILVERCODERS SqlUnify project can convert PostgreSQL queries to other dialects (MySQL, FirebirdSQL, MSSQL, Oracle...)! 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· commentsMySQL transformationsTRUE1FALSE0UNKNOWNULLSELECT * FROM table LIMIT 20 OFFSET 10SELECT * FROM table LIMIT 10,20SELECT * FROM table OFFSET 10FAILSELECT * FROM table LIMIT 10,-1INTERVAL "1 day"INTERVAL 1 dayINTERVAL "2 days"INTERVAL 2 dayINTERVAL "2 days 1 hour 15 minutes"INTERVAL 2 day + INTERVAL 1 hour + INTERVAL 15 minuteexpression::typeCASE(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::BOOLCASE(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 tableSELECT IF(boolean_expression IS NULL, 'UNKNOW', IF(boolean_expression, 'TRUE', 'FALSE'))SELECT '2005-01-01'::DATETIME AT TIMEZONE '+01:00'FAILINSERT INTO table VALUES(DEFAULTFAILINSERT INTO table (field) VALUES(DEFAULT)INSERT INTO table (field) VALUES(DEFAULT(field))SELECT "field" FROM "table"SELECT `field` FROM `table`SELECT |/a FROM tableSELECT SQRT(a) FROM tableSELECT ||/a FROM tableSELECT POWER(a, 1/3) FROM tableSELECT a ^ b FROM tableSELECT POWER(a, b) FROM tableSELECT @a FROM tableSELECT ABS(a) FROM tableSELECT a IS TRUE FROM tableSELECT IF(a IS NULL, 0, a != 0) FROM tableSELECT a IS FALSE FROM tableSELECT IF(a IS NULL, 0, a = 0) FROM tableSELECT a IS UNKOW FROM tableSELECT a IS NULL FROM tableSELECT a IS NOT TRUE FROM tableSELECT IF(a IS NULL, 1, a = 0) FROM tableSELECT a IS NOT FALSE FROM tableSELECT IF(a IS NULL, 1, a != 0) FROM tableSELECT a IS NOT UNKOW FROM tableSELECT a IS NOT NULL FROM tableSELECT a IS DISTINCT FROM b FROM tableSELECT IF(a IS NULL, IF(b IS NULL, 0, 1), IF(b IS NULL, 1, a != b)) FROM tableSELECT a # b FROM tableSELECT a ^ b FROM tableSELECT ~a FROM tableSELECT ~(~(~(a) - 1)) FROM tableSELECT a || b FROM tableSELECT CONCAT(a, b) FROM tableSELECT a LIKE b FROM tableSELECT a LIKE BINARY b FROM tableSELECT a ~~ b FROM tableSELECT a LIKE BINARY b FROM tableSELECT a NOT LIKE b FROM tableSELECT a NOT LIKE BINARY b FROM tableSELECT a !~~ b FROM tableSELECT a NOT LIKE BINARY b FROM tableSELECT a ILIKE b FROM tableSELECT a LIKE b FROM tableSELECT a ~~* b FROM tableSELECT a LIKE b FROM tableSELECT a NOT ILIKE b FROM tableSELECT a NOT LIKE b FROM tableSELECT a !~~* b FROM tableSELECT a NOT LIKE b FROM tableSELECT a SIMILAR TO b FROM tableFAILSELECT a NOT SIMILAR TO b FROM tableFAILSELECT a ~ b FROM tableSELECT BINARY(a) REGEXP b FROM tableSELECT a ~* b FROM tableSELECT a REGEXP b FROM tableSELECT a !~ b FROM tableSELECT NOT (BINARY(a) REGEXP b ) FROM tableSELECT a !~* b FROM tableSELECT NOT(a REGEXP b) FROM tableSELECT date + integer FROM tableSELECT date + INTERVAL integer DAY FROM talbeSELECT date + time FROM tableSELECT ADDTIME(date, time) FROM tableSELECT time + date FROM tableSELECT ADDTIME(date, time) FROM tableSELECT interval + interval FROM tableFAILSELECT time + interval FROM tableFAILSELECT interval + time FROM tableFAILSELECT date - date FROM tableSELECT TO_DAYS(date) - TO_DAYS(date)SELECT time - time FROM tableFAILSELECT date - integer FROM tableSELECT date - INTERVAL integer DAY FROM talbeSELECT interval - interval FROM tableFAILSELECT time - interval FROM tableFAILSELECT interval - time FROM tableFAILSELECT timestamp - timestamp FROM tableFAILSELECT -INTERVAL "1 day" FROM tableSELECT INTERVAL -1 DAY FROM tableSELECT interval * float FROM tableFAILSELECT interval / float FROM tableFAILSELECT (date1, date2) OVERLAPS (date3, date4) FROM tableSELECT (NOT((date4 < date1) OR (date3 > date2))) FROM tableSELECT (date1, interval1) OVERLAPS (date2, interval2) FROM tableSELECT (NOT((date2 + interval2 < date1) OR (date2 > date1 + interval1))) FROM tableSELECT CBRT(a) FROM tableSELECT POWER(a, 1/3) FROM tableSELECT LOG(a) FROM tableSELECT LOG(10, a) FROM tableSELECT RANDOM()SELECT RAND()SELECT SETSEED()FAILSELECT TRUNC(a) FROM tableSELECT TRUNCATE(a, 0) FROM talbeSELECT WIDTH_BUCKET()FAILSELECT CONVERT()FAILSELECT OVERLAY(expression1 PLACING expression2 FROM expression3 FOR expression4 FROM tableSELECT CONCAT(SUBSTR(expression1, 1, expression3 - 1), expression2, SUBSTR(expression1, expression3 + expression4)) FROM tableSELECT OVERLAY(expression1 PLACING expression2 FOR expression4) FROM tableFAILSELECT OVERLAY(expression1 PLACING expression2 FROM expression3) FROM tableFAILSELECT OVERLAY(expression1 PLACING expression2) FROM tableFAILSUBSTRING with regular expressionFAILSELECT CHR(a) FROM tableSELECT CHAR(a) FROM talbeSELECT DECODE()FAILSELECT ENCODE()FAILSELECT INITCAP()FAILSELECT LTRIM(string, ' ') FROM tableSELECT LTRIM(string) FROM tableSELECT LTRIM(string, char) FROM tableSELECT TRIM(LEADING char FROM string) FROM tableSELECT LTRIM(string, string)FAILSELECT PG_CLIENT_ENCODING()FAILSELECT QUOTE_IDENT()FAILSELECT QUOTE_LITERAL()FAILSELECT RTRIM(string, string)FAILSELECT RTRIM(string, ' ') FROM tableSELECT RTRIM(string) FROM tableSELECT RTRIM(string, char) FROM tableSELECT TRIM(TRAILING char FROM string) FROM tableSELECT RTRIM(string, string)FAILSELECT SPLIT_PART()FAILSELECT STRPOS(string1, string2) FROM tableSELECT POSITION(string2 IN string1) FROM tableSELECT TO_ASCII()FAILSELECT TO_HEX()FAILSELECT TRANSLATE()FAILSELECT AGE()FAILSELECT DATE_PART("CENTURY", date) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM date) + 99) / 100) FROM tableSELECT DATE_PART("CENTURY", interval) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' interval - INTERVAL 1 month - INTERRVAL 1 day) + 99) / 100) FROM tableSELECT DATE_PART("DAY", date) FROM tableSELECT DAYOFMONTH(date) FROM tableSELECT DATE_PART("DAY", interval) FROM tableSELECT DAYOFMONTH('0000-01-01 00:00:00' + interval) FROM tableSELECT DATE_PART("DECADE", date) FROM tableSELECT FLOOR(EXTRACT(YEAR FROM date) / 10) FROM tableSELECT DATE_PART("DECADE", interval) FROM tableSELECT FLOOR(EXTRACT(YAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM tableSELECT DATE_PART("DOW", date) FROM tableSELECT (DAYOFWEEK(date) -1) FROM tableSELECT DATE_PART("DOW", interval) FROM tableFAILSELECT DATE_PART("DOY", date) FROM tableSELECT DAYOFYEAR(date) FROM tableSELECT DATE_PART("DOY", interval) FROM tableFAILSELECT DATE_PART("EPOCH", date) FROM tableSELECT UNIX_TIMESTAMP(date) FROM tableSELECT DATE_PART("EPOCH", interval) FROM tableSELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + interval) FROM tableSELECT DATE_PART("HOUR", date) FROM tableSELECT HOUR(date) FROM tableSELECT DATE_PART("HOUR", interval) FROM tableSELECT HOUR('0000-01-01 00:00:00' + interval) FROM tableSELECT DATE_PART("MICROSECONDS", date) FROM tableSELECT (MICROSECOND(date) + 1000000 * SECOND(date)) FROM tableSELECT DATE_PART("MICROSECONDS", interval) FROM tableSELECT (MICROSECOND('0000-01-01 00:00:00' + interval) + 1000000 * SECOND('000-01-01 00:00:00' + interval)) FROM tableSELECT DATE_PART("MILLENIUM", date) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM date) + 999) / 1000) FROM tableSELECT DATE_PART("MILLENIUM", interval) FROM tableSELECT FLOOR((EXTRACt(YEAR FROM '0000-01-01 00:00:00') + 999) / 1000) FROM tableSELECT DATE_PART("MILISECONDS", date) FROM tableSELECT (FLOOR(MICROSECONDS(date)) / 1000 + 1000 * SECOND(date)) FROM tableSELECT DATE_PART("MILISECONDS", interval) FROM tableSELECT (FLOOR(MILISECONDS('0000-01-01 00:00:00' + interval)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + interval)) FROM tableSELECT DATE_PART("MINUTE", date) FROM tableSELECT MINUTE(date) FROM tableSELECT DATE_PART("MINUTE", interval) FROM tableSELECT MINUTE('0000-01-01 00:00:00' + interval) FROM tableSELECT DATE_PART("MONTH", date) FROM tableSELECT MONTH(date) FROM tableSELECT DATE_PART("MONTH", interval) FROM tableSELECT (MONTH('0000-01-01 00:00:00' + interval) - 1) FROM tableSELECT DATE_PART("QUARTER", date) FROM tableSELECT FLOOR((MONTH(date) - 2 / 3)) FROM tableSELECT DATE_PART("QUARTER", interval) FROM tableSELECT FLOOR((MONTH('0000-01-01 00:00:00' + interval) - 1) / 3) FROM tableSELECT DATE_PART("SECOND", date) FROM tableSELECT (SECOND(date) + MICROSECOND(date) / 1000000) FROM tableSELECT DATE_PART("SECOND", interval) FROM tableSELECT (SECOND('0000-01-01 00:00:00' + interval) + MICROSECOND('0000-01-01 00:00:00' + interval) / 1000000) FROM tableSELECT DATE_PART("WEEK", date) FROM tableSELECT WEEK(date, 7) FROM tableSELECT DATE_PART("WEEK", interval) FROM tableFAILSELECT DATE_PART("YEAR", date) FROM tableSELECT YEAR(date) FROM tableSELECT DATE_PART("YEAR", interval) FROM tableSELECT YEAR('0000-01-01' + interval - INTERVAL 1 month - INTERVAL 1 day) FROM tableSELECT EXTRACT("CENTURY", date) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM date) + 99) / 100) FROM tableSELECT EXTRACT("CENTURY", interval) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERRVAL 1 day) + 99) / 100) FROM tableSELECT EXTRACT(DAY FROM date) FROM tableSELECT DAYOFMONTH(date) FROM tableSELECT EXTRACT(DAY FROM interval) FROM tableSELECT DAYOFMONTH('0000-01-01 00:00:00' + interval) FROM tableSELECT EXTRACT(DECADE FROM date) FROM tableSELECT FLOOR(EXTRACT(YEAR FROM date) / 10) FROM tableSELECT EXTRACT(DECADE FROM interval) FROM tableSELECT FLOOR(EXTRACT(YAR FROM '0000-01-01 00:00:00' + interval - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM tableSELECT EXTRACT(DOW FROM date) FROM tableSELECT (DAYOFWEEK(date) -1) FROM tableSELECT EXTRACT(DOW FROM interval) FROM tableFAILSELECT EXTRACT(DOY FROM date) FROM tableSELECT DAYOFYEAR(date) FROM tableSELECT EXTRACT(DOY FROM interval) FROM tableFAILSELECT EXTRACT(EPOCH FROM date) FROM tableSELECT UNIX_TIMESTAMP(date) FROM tableSELECT EXTRACT(EPOCH FROM interval) FROM tableSELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + interval) FROM tableSELECT EXTRACT(HOUR FROM date) FROM tableSELECT HOUR(date) FROM tableSELECT EXTRACT(HOUR FROM interval) FROM tableSELECT HOUR('0000-01-01 00:00:00' + interval) FROM tableSELECT EXTRACT(MICROSECONDS FROM date) FROM tableSELECT (MICROSECOND(date) + 1000000 * SECOND(date)) FROM tableSELECT EXTRACT(MICROSECONDS FROM interval) FROM tableSELECT (MICROSECOND('0000-01-01 00:00:00' + interval) + 1000000 * SECOND('000-01-01 00:00:00' + interval)) FROM tableSELECT EXTRACT(MILLENIUM FROM date) FROM tableSELECT FLOOR((EXTRACT(YEAR FROM date) + 999) / 1000) FROM tableSELECT EXTRACT(MILLENIUM FROM interval) FROM tableSELECT FLOOR((EXTRACY(YEAR FROM '0000-01-01 00:00:00' + FROM tableSELECT EXTRACT(MILISECONDS FROM date) FROM tableSELECT (FLOOR(MILISECONDS(date)) / 1000 + 1000 * SECOND(date)) FROM tableSELECT EXTRACT(MILISECONDS FROM interval) FROM tableSELECT (FLOOR(MILISECONDS('0000-01-01 00:00:00' + interval)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + interval)) FROM tableSELECT EXTRACT(MINUTE FROM date) FROM tableSELECT MINUTE(date) FROM tableSELECT EXTRACT(MINUTE FROM interval) FROM tableSELECT MINUTE('0000-01-01 00:00:00' + interval) FROM tableSELECT EXTRACT(MONTH FROM date) FROM tableSELECT MONTH(date) FROM tableSELECT EXTRACT(MONTH FROM interval) FROM tableSELECT (MONTH('0000-01-01 00:00:00' + interval) - 1) FROM tableSELECT EXTRACT(QUARTER FROM date) FROM tableSELECT FLOOR((MONTH(date) - 2 / 3)) FROM tableSELECT EXTRACT(QUARTER FROM interval) FROM tableSELECT FLOOR((MONTH('0000-01-01 00:00:00' + interval) - 1) / 3) FROM tableSELECT EXTRACT(SECOND FROM date) FROM tableSELECT (SECOND(date) + MICROSECOND(date) / 1000000) FROM tableSELECT EXTRACT(SECOND FROM interval) FROM tableSELECT (SECOND('0000-01-01 00:00:00' + interval) + MICROSECOND('0000-01-01 00:00:00' + interval) / 1000000) FROM tableSELECT EXTRACT(WEEK FROM date) FROM tableSELECT WEEK(date, 7) FROM tableSELECT EXTRACT(WEEK FROM interval) FROM tableFAILSELECT EXTRACT(YEAR FROM date) FROM tableSELECT YEAR(date) FROM tableSELECT EXTRACT(YEAR FROM interval) FROM tableSELECT YEAR('0000-01-01' + interval - INTERVAL 1 month - INTERVAL 1 day) FROM tableSELECT DATE_TRUNC("CENTURY", date) FROM tableFAILSELECT DATE_TRUNC("CENTURY", interval) FROM tableFAILSELECT DATE_TRUNC("DAY", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-%d 00:00:00") FROM tableSELECT DATE_TRUNC("DAY", interval) FROM tableFAILSELECT DATE_TRUNC("DECADE", date) FROM tableFAILSELECT DATE_TRUNC("DECADE", interval) FROM tableFAILSELECT DATE_TRUNC("HOUR", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-%d %H:00:00") FROM tableSELECT DATE_TRUNC("HOUR", interval) FROM tableFAILSELECT DATE_TRUNC("MICROSECONDS", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i%s.%f") FROM tableSELECT DATE_TRUNC("MICROSECONDS", interval) FROM tableFAILSELECT DATE_TRUNC("MILISECONDS", date) FROM tableFAILSELECT DATE_TRUNC("MILISECONDS", interval) FROM tableFAILSELECT DATE_TRUNC("MILLENNIUM", date) FROM tableFAILSELECT DATE_TRUNC("MILLENNIUM", interval) FROM tableFAILSELECT DATE_TRUNC("MINUTE", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i:00") FROM tableSELECT DATE_TRUNC("MINUTE", interval) FROM tableFAILSELECT DATE_TRUNC("MONTH", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-01 00;00:00") FROM tableSELECT DATE_TRUNC("MONTH", interval) FROM tableFAILSELECT DATE_TRUNC("SECOND", date) FROM tableSELECT DATE_FORMAT(date, "%Y-%m-%d %H:%i:%s") FROM tableSELECT DATE_TRUNC("SECOND", interval) FROM tableFAILSELECT DATE_TRUNC("YEAR", date) FROM tableSELECT DATE_FORMAT(date, "%Y-01-01 00:00:00") FROM tableSELECT DATE_TRUNC("YEAR", interval) FROM tableFAILSELECT ISFINITE() FROM tableFAILSELECT TIMEOFDAY() FROM tableFAILSELECT TIMEZONE() FROM tableFAILSELECT 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 tableFAILSELECT DATE_FORMAT() FROM tableFAILSELECT TO_TIMESTAMP() FROM tableFAILSELECT TO_NUMBER() FROM tableFAILSELECT TO_CHAR(date, '%') FROM tableSELECT DATE_FORMAT(date, '%%') FROM tableSELECT TO_CHAR(date, '"anytext %"') FROM tableSELECT DATE_FORMAT(date, 'anytext %%') FROM tableSELECT TO_CHAR(date, 'FMHH') FROM tableSELECT DATE_FORMAT(date, '%l') FROM tableSELECT TO_CHAR(date, 'HH') FROM tableSELECT DATE_FORMAT(date, '%I') FROM tableSELECT TO_CHAR(date, 'FMHH12') FROM tableSELECT DATE_FORMAT(date, '%l') FROM tableSELECT TO_CHAR(date, 'HH12') FROM tableSELECT DATE_FORMAT(date, '%I') FROM tableSELECT TO_CHAR(date, 'FMHH24') FROM tableSELECT DATE_FORMAT(date, '%k') FROM tableSELECT TO_CHAR(date, 'HH24') FROM tableSELECT DATE_FORMAT(date, '%H') FROM tableSELECT TO_CHAR(date, 'MI') FROM tableSELECT DATE_FORMAT(date, '%i') FROM tableSELECT TO_CHAR(date, 'SS') FROM tableSELECT DATE_FORMAT(date, '%s') FROM tableSELECT TO_CHAR(date, 'US') FROM tableSELECT DATE_FORMAT(date, '%f') FROM tableSELECT TO_CHAR(date, 'AM') FROM tableSELECT DATE_FORMAT(date, '%p') FROM tableSELECT TO_CHAR(date, 'PM') FROM tableSELECT DATE_FORMAT(date, '%p') FROM tableSELECT TO_CHAR(date, 'YYYY') FROM tableSELECT DATE_FORMAT(date, '%Y') FROM tableSELECT TO_CHAR(date, 'IYYY') FROM tableSELECT DATE_FORMAT(date, '%Y') FROM tableSELECT TO_CHAR(date, 'YY') FROM tableSELECT DATE_FORMAT(date, '%Y') FROM tableSELECT TO_CHAR(date, 'IY') FROM tableSELECT DATE_FORMAT(date, '%Y') FROM tableSELECT TO_CHAR(date, 'Month') FROM tableSELECT DATE_FORMAT(date, '%M') FROM tableSELECT TO_CHAR(date, 'Mon') FROM tableSELECT DATE_FORMAT(date, '%b') FROM tableSELECT TO_CHAR(date, 'FMMM') FROM tableSELECT DATE_FORMAT(date, '%c') FROM tableSELECT TO_CHAR(date, 'MM') FROM tableSELECT DATE_FORMAT(date, '%M') FROM tableSELECT TO_CHAR(date, 'Day') FROM tableSELECT DATE_FORMAT(date, '%W') FROM tableSELECT TO_CHAR(date, 'Dy') FROM tableSELECT DATE_FORMAT(date, '%a') FROM tableSELECT TO_CHAR(date, 'DDD') FROM tableSELECT DATE_FORMAT(date, '%j') FROM tableSELECT TO_CHAR(date, 'FMDD') FROM tableSELECT DATE_FORMAT(date, '%e') FROM tableSELECT TO_CHAR(date, 'DD') FROM tableSELECT DATE_FORMAT(date, '%d') FROM table

SILVERCODERS SqlUnify Related Software