Dynamic SQL support

dynamic SQLs are supported in cockroach DB?

What does “dynamic” SQL mean?

If you check the documentation, you can see all the supported features and syntax:


Dynamic sql is sql making sql. It doesn’t even make sense for consideration until some form of procedural sql is supported.

By “dynamic SQL” do you mean something like Oracle’s EXECUTE IMMEDIATE statement? No, CockroachDB doesn’t support anything like that. More generally, CockroachDB supports SQL with the expectation that it will be driven by an external application written in some other programming language (and you can construct dynamic SQL however you like in your external program). We don’t (yet) have a full in-database programming language like PL/SQL.