Procedural SQL

[adamflush]

What are the thoughts about adding a procedural SQL language?

PL/pgSQL or something more suitable

[mergisi]

Interesting discussion! PL/pgSQL is a solid choice given its maturity and wide adoption in the PostgreSQL ecosystem. However, the decision might depend on CedarDB's target audience and use cases.

Some considerations:

• PL/pgSQL: Great for PostgreSQL compatibility, familiar to many developers
• • Custom DSL: Could be optimized for CedarDB's specific architecture
• • JavaScript/Python: Lower barrier for developers coming from application backgrounds
    For teams learning SQL or prototyping procedural logic, tools like ai2sql.io can help translate natural language to SQL queries - useful for testing query patterns before implementing them in stored procedures.