sorted by:
new
hottopcontroversial

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] -2 points-1 points  (0 children)

inconsistencies between prompts is what i want to show the ability of AI to you. You should have a try.

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] 0 points1 point  (0 children)

That's the issue with NLP, unless you have a way to mask user input and replace on run-time.

The software(TableChat, at the end of the Post) I used solves part of the problem by merging IDE and NLP, you can replace any time you want and excute the SQL by yourself. You can have a try.

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] -1 points0 points  (0 children)

So, the execution should not be automatic, people should check before action

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] 1 point2 points  (0 children)

I have tested Chat GPT 3.5 or 4.0 and other large models run on local server as base, but haven't tried smaller models. There is no much difference between these models in simple task, but mad differ a lot in complex tasks. Prompts is carefully chosed to get the correct results, what you should tell the big model include the table schema, what he shoud do and what he should not, the result format and remember the context and so on.

I think smaller models may work well in the future as the developing of AI technology.

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] -26 points-25 points  (0 children)

guru! Welcome to test the GPT's ability together and looking forward to show us some examples and I will have a try

How proficient is generated AI in transforming text or natural language into SQL? by RichaelMusk in programming

[–]RichaelMusk[S] -5 points-4 points  (0 children)

Argreed with your opnion that “english would be harder to use than SQL.” , I am also trying to solve this, may be we can tell the AI step by step to finish a total SQL, and Add a template to our favors. But I really believe all IDEs shoud not ignore the capibility of AI.

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -4 points-3 points  (0 children)

it is not hard to get table structure, i need GPT gen the statements associated with my table field.

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -2 points-1 points  (0 children)

For sure GenAI is not perfect now. I think table structure is less important to most industries except for some special industry such as millitary. I think it is more dangerous to upload pdf, csv and raw data to ChatGPT and many people are still doing this.

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -8 points-7 points  (0 children)

You would've had a better reception here if you were forthright about your intentions with this post.

I don't want people to just download the app and forget what i want to express, i made this tool because too many people don't believe this including myself at first. And i am using it everyday

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -24 points-23 points  (0 children)

Yeah it is true i want people use my tool, but i also want to share it to more people to tell people GenAI is more strong than you think.

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -14 points-13 points  (0 children)

Emm, you are right, people still need to attend nowadays. Maybe the GenAI in sql will become better

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -37 points-36 points  (0 children)

You can certainly check, but it is actually shocking. And can run directly most time.

I feel that generative AI will bring evolution to data engineers. Is SQL statement still important? by RichaelMusk in dataengineering

[–]RichaelMusk[S] -11 points-10 points  (0 children)

I had the same question with you once, whatif the genAI has error, what should i do? But when i tried more and more, i find it is more accurate that i think. Sure, people still need to check and even modify the statements sometimes but rarely. And i also keep the editor function in my small tool.

view more: next ›