И вот как бы в #aws завезли Babelfish SQL Server-compatible end-point for PostgreSQL

https://aws.amazon.com/blogs/opensource/want-more-postgresql-you-just-might-like-babelfish/

#postgresql #mssql #sql #databse #amazon

duckdb going mad...

UNION Type

CREATE TABLE messages(u UNION(num INT, error VARCHAR));
INSERT INTO messages VALUES (42);
INSERT INTO messages VALUES ('oh my globs');

FROM-first

-- SELECT clause is optional, SELECT * is implied (if not included)
FROM tbl;

-- first 5 rows of the table
FROM tbl LIMIT 5;

-- SELECT can be used after the FROM
FROM tbl SELECT l_orderkey;

-- insert all data from tbl1 into tbl2
INSERT INTO tbl2 FROM tbl1;

BTW SQL standard already has special syntax for it:

TABLE tbl;

COLUMNS Expression

SELECT MIN(COLUMNS(*)), COUNT(*) from obs;
SELECT COLUMNS('val[0-9]+') from obs;

List comprehension support

SELECT [x + 1 for x in [1, 2, 3]] AS l;

here we go again:
https://www.linkedin.com/feed/update/urn:li:activity:7224013497884454912?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7224013497884454912%2C7224078490243850241%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287224078490243850241%2Curn%3Ali%3Aactivity%3A7224013497884454912%29

(feel free to JOIN this hate speech)

Hi
Do you remember that I have a startup, right? 🙂

Just in case, I remind you:
Dwh.dev is the best tool to work with Data Lineage in Snowflake.

So, we've stuffed Dwh.dev into the Snowflake Marketplace.
The whole thing. The whole Dwh.dev.

Among other things, we're the first Data Lineage provider in the Snowflake Marketplace.

That's pretty cool.

So it would really help me out if you could like this LinkedIn and this Reddit and Twitter and HN post.

Thanks 🙂