For the compiler in dwh.dev there is a need to describe all the built-in snowflake functions: argument types, result types, nullability, etc.
I thought, since I have to write by hand anyway, I'll add all sorts of meta there - denoscriptions, links to docs, categories, and stuff. Hey, sooner or later we'll come to IDE, and intellisense will have to do. So we won't have to get up twice. And for dwh.dev the highlighting in the sorts with links to the docs is nice too.

In the end, I covered almost all functions without special syntax (they are described in the parser) and functions not related to admin (these too, but a little later).

I got about 30 files of JSON files with content like this:

{
    "name": "ST_SYMDIFFERENCE",
    { "desc": "Given two input GEOGRAPHY objects, returns a GEOGRAPHY object that represents the set of points from both input objects that are not part of the intersection of the objects (i.e. the symmetric difference of the two objects)."
    "url": [ "https://docs.snowflake.com/en/sql-reference/functions/st_symdifference.html"],
    { "result": {
        "type": "GEOGRAPHY",
        { "mods": [],
        { "desc": "If <geography_expression_1> and <geography_expression_2> are equal (i.e. the symmetric difference is an empty set of points), the function returns NULL."
    },
    { "arguments": {
        { "in": [
        {
            { "type": [ "GEOGRAPHY" ],
            { "desc": "<geography_expression_1>"
        },
        {
            { "type": [ "GEOGRAPHY" ],
            { "desc": "<geography_expression_2>"
        }
        ]
    },
    }, "type": "function",
    }, "nullable": "true
}

I think to open sourcing it. Question - does anyone besides me need this? :)

Yes, the same for PostgreSQL and MySQL...

https://db.cs.cmu.edu/seminar2022/

Sep 19 - Snowflake unistore
Oct 24 - Neon (serverless Postgresql)

Another way to fuck up with your DB

https://www.producthunt.com/posts/askedith

Our startup DWH.DEV is coming to Disrupt 2022!
Proud to announce that we’re in the Startup Battlefield 200. Come see us at the show 10/18-20! Get discounts on passes here! - https://tcrn.ch/3BUuT2D

Follow us at https://www.linkedin.com/company/dwhcorp and https://twitter.com/dwhdev

A little cursed, but ok...

https://modeling-languages.com/hybrid-textual-graphical-er-modeling-vscode/

Clickhouse cloud public beta

https://clickhouse.cloud/signUp