Generating SQL statements (Discussion-Topic)

dpfried / incoder

Generative model for code infilling and synthesis

291 stars 25 forks source link

Generating SQL statements (Discussion-Topic) #11

Closed OleApp closed 1 year ago

OleApp commented 1 year ago

Hi all!

I am trying to generate SQL statements with the InCoder model. The first attempts look very promising! Does anyone have an idea how I can prompt the model with my database structure? Something trivial like what tables and attributes are there.

Thanks for any food for thought! Greetings, Ole

dpfried commented 1 year ago

Hi Ole, Thanks for your interest! Perhaps others could weigh in here as well, but I would recommend looking the setup that Freda and some of us used in this paper: https://arxiv.org/abs/2204.11454, https://github.com/facebookresearch/mbr-exec for the Spider experiments. I am not sure whether this formatting would work well with InCoder, but it might.

OleApp commented 1 year ago

Hi @dpfried! Thank you very much for your response and the hint! It works like a charm! It was possible for me to generate even nested queries!

Best regards, Ole!