Remix.run Logo
dfabulich a day ago

This looks really cool, but I'm not going to use it today, because it only supports SQLite, with Postgres and SQL Server "coming soon." This seems like a very odd starting point, especially for a paid tool. I don't have any SQLite databases I'd want to explore, and certainly none with "massive tables." I'd want to use it for Postgres and MySQL/MariaDB first.

Also, if autocomplete is what we care about, PRQL support seems like it will offer the best experience. https://prql-lang.org/ PRQL queries transpile to SQL. Just having the `FROM` clause first does wonders for autocomplete.

SkiFire13 20 hours ago | parent [-]

This reminds me of the pipe syntax for Google's BigQuery. Other helping with autocomplete it also significantly reduces the amount of WITH statements and subqueries needed