holistics / holistics/dbml

Is it possible to add aditional SQL statements that are executed "as are" at the end of the generated SQL Script?

Open
#290 0 comments 1 reaction 1 assignee Claimed by @huydo862003 View on GitHub
enhancement
Dominant language
JavaScript
Stars
3.7k
Forks
233
Avg merge
1d 23h
Merged PRs (30d)
4

Description

Greetings, I would like to start this issue saying thanks for such amazing tool that has helped me for more than a couple of years at this point.

The title of my issue might be confusing but I hope to clarify it with the following use case:
I am in need of declaring a complex ((or maybe not so much)) index definition, something like this `CREATE UNIQUE INDEX ON "auth"."users" (is_root) WHERE is_root = true`.
So far I haven´t been able to find any way of declaring such thing using DBML, so I the only option left is to modify the generated script, which is not optimum.

Is it there any way of declaring SQL statements that are executed at the end of the generated SQL Script, "as are"?.
I'm concerned that such thing would hurt the ability to export to other databases but It would be a nice opt-in feature.

Thanks for reading.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.