rhombus-brainstorming VS JSqlParser

The Racket team has been embarking on the Rhombus project with something they're calling shrubbery notation. The most recent Racket Con (https://con.racket-lang.org/) has several presentations on the topic, and there's a GitHub repo (https://github.com/racket/rhombus-brainstorming) tracking discussion. For what it's worth, I strongly dislike the heavy use of : in this notation.

Once you become a skeptic, other warts began to appear such as the culture (1,2) of the language and one of the active academic members putting a lot of effort into changing the syntax. I concluded that I might as well spend my time just learning common lisp as then I might have a tool I could use. Everything is old in common lisp, and I am coming to recognize that as a good thing. Re-inventing the wheel is not always useful, and a few libraries that everyone uses means they probably function and build.

Matthew has been working on a [prototype](https://github.com/racket/rhombus-brainstorming/pull/163) that works on the current snapshot version of Racket.

It is possible to use to write some basic things and most existing Racket libraries are usable with the prototype.

It is called rhombus and there is an open discussion going on at https://github.com/racket/rhombus-brainstorming

rhombus-brainstorming

I wonder if this is a topical thread to check if anyone is aware of a Java based solution to parse a CREATE VIEW statement to get a mapping between the view columns and the corresponding source table columns. I checked out jsqlparser[0] and it does produce an AST which can be parsed using the visitor-pattern[1] but was wondering if there is a more "out-of-the-box" solution. Due to various reasons, querying the database information schema is not an option I can pursue.

[0]: https://github.com/JSQLParser/JSqlParser

[1]: https://en.wikipedia.org/wiki/Visitor_pattern

JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.

Interesting coincidence - I'm working on a parser that parses the AST produced by JSqlParser[0] for a create view statement to generate mapping between the columns of a view and the columns of its underlying table. It is an interesting example of having to use the visitor pattern[1].

[0]: https://github.com/JSQLParser/JSqlParser