One paragraph of prompt can produce a working SQL engine

Jeff Dean, Noam ShazeerJeff Dean & Noam Shazeer — 25 years at Google: from PageRank to AGIat 40:00

From the conversation

Someone external tried it, and they basically prompted it and said, "I'd like you to implement a SQL processing database system with no external dependencies, and please do that in C." From what the person said, it actually did a quite good job. It generated a SQL parser and a tokenizer and a query planning system and some storage format for the data on disk and actually was able to handle simple queries. From that prompt, which is like a paragraph of text or something, to get even an initial cut at that seems like a big boost in productivity for software developers. I think you might end up with other kinds of systems that maybe don't try to do that in a single semi-interactive, "respond in 40 seconds" kind of thing but might go off for 10 minutes and might interrupt you after five minutes saying, "I've done a lot of this, but now I need to get some input. Do you care about handling video or just images or something?" That seems like you'll need ways of managing the workflow if you have a lot of these background activities happening. Can you talk more about that?…

Machine-generated transcript. The excerpt can include the interviewer and other voices, and the transcription may contain errors. The rest is in the episode →

Summary

A sufficiently capable coding model can generate a functioning SQL processing system in C—including a parser, tokenizer, query planner, and storage format—from a single paragraph-length prompt. This level of output from minimal input represents a significant leap in productive capability, suggesting that advanced models can compress large amounts of engineering work into a single generation step.

Watch the clip on YouTubeStarts at 40:00

Concept

Explosion

Related clips