Replacing a SQL analyst with 26 recursive GPT prompts

#1

Post by kvh » Wed, Jan 25, 2023, 5:20 PM UTC

Replacing a SQL analyst with 26 recursive GPT prompts
patterns.app

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#2

Post by kilotaras » Wed, Jan 25, 2023, 5:40 PM UTC

Interesting.

Probably won't work for harder queries, but would be a good tool to make simpler queries, or parts of harder ones.

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#3

Post by LastTrain » Wed, Jan 25, 2023, 5:52 PM UTC

I used to work for a company that paid loads of money to an Oracle consultancy group to do things like optimize queries. Sometimes they'd even do a better job than the Oracle query optimizer :-)

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#4

Post by logicallee » Wed, Jan 25, 2023, 5:55 PM UTC

kilotaras wrote: post #2

Interesting. Probably won't work for harder queries, but would be a good tool to make simpler queries, or parts of harder ones.

my opinion: probably will work for harder queries, because GPT is a form of general intelligence.

(At least ChatGPT is. It is a much more advanced form of intelligence than davinci-003, which the poster used.)

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#5

Post by triyambakam » Wed, Jan 25, 2023, 5:56 PM UTC

logicallee wrote: post #4

kilotaras wrote: post #2

Interesting. Probably won't work for harder queries, but would be a good tool to make simpler queries, or parts of harder ones.

my opinion: probably will work for harder queries, because GPT is a form of general intelligence. (At least ChatGPT is. It is a much more advanced form of intelligence than davinci-003, which the poster used.)

> GPT is a form of general intelligence.

Is it really? I hadn't heard that

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#6

Post by jeltz » Wed, Jan 25, 2023, 5:57 PM UTC

kilotaras wrote: post #2

Interesting. Probably won't work for harder queries, but would be a good tool to make simpler queries, or parts of harder ones.

Yeah, it doesn't. A friend of mine played around with this and on trickier questions you got confidently incorrect answers.

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#7

Post by nivenkos » Wed, Jan 25, 2023, 5:57 PM UTC

All the NoCode and LLM stuff feels like this though - it works well for simple demos, but is useless for the complexity of the real world especially if errors are costly.

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#8

Post by extr » Wed, Jan 25, 2023, 5:57 PM UTC

Wonder what the costs are for this per question? I imagine supplying so many tokens for context makes the querying a lot more expensive. Though still no doubt cheaper than hiring another analyst.

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#9

Post by arrosenberg » Wed, Jan 25, 2023, 5:57 PM UTC

You didn't replace a SQL Analyst, you just gave them a query generator. End data consumers don't understand the data model, assumptions, quirks, etc. If they fire the analyst, they are going to wind up drawing a lot of bad conclusions on anything more complicated than simple aggregations.

Re: Replacing a SQL analyst with 26 recursive GPT prompts

#10

Post by LeanderK » Wed, Jan 25, 2023, 5:58 PM UTC

triyambakam wrote: post #5

logicallee wrote: post #4

Earlier quoted context omitted.

my opinion: probably will work for harder queries, because GPT is a form of general intelligence. (At least ChatGPT is. It is a much more advanced form of intelligence than davinci-003, which the poster used.)

> GPT is a form of general intelligence. Is it really? I hadn't heard that

no it's not. It's just a neural network. Although it's impressive nobody is seriously calling it "general intelligence".