from Hacker News

SQL and NoSQL database query co-pilot

by Avernar on 2/3/23, 10:53 PM with 2 comments

• by donut2d on 2/3/23, 11:10 PM

  This looks great. I'll have to play around with it.

  For once, I'd love to have a nice UI around this so I don't need to search docs, google mongo syntax, check the schema, and edit the code in different spots

  Wonder if it can it write data pipelines with unit/regression testing and model the data for decision making. Probably not but one day it might. Generally I see tools like these as potential supplements for what my team does, not replacements.

• by Firebox on 2/3/23, 11:13 PM

  Gathering data through queries should be a straightforward task and I can imagine this creates value, but understanding the complexities of the data is much more challenging to solve. For example, the fact that business unit A and business unit B have different ways of counting metric X due to a random director's decision made like a decade ago, or that there is a missing two weeks of data from a table due to a load process failure, or that one table's timestamp is in a different time zone compared to all the others, I doubt it could handle

  As a seasoned Data Scientist, I've witnessed the rise and fall of many tools and technologies. However, I don't believe that we are close to eliminating the need for human involvement. Domain expertise is often underestimated, the time it takes to type a query is overestimated and the number of times you get a random shower thought that makes you realize you've been asking the wrong question all along are countless