Please add support for views

[espindola]

As far as I can tell there is no way to create a view with sea-query.

[billy1624]

Hey @espindola, sorry for the delay. Yes, it's not supported at the moment. And we don't have a plan for supporting it in near future.

For those of you who need this feature, I'm calling for your contributions :)

Some references

• SQLite: https://www.sqlite.org/lang_createview.html
• PostgreSQL: https://www.postgresql.org/docs/current/sql-createview.html
• MySQL: https://dev.mysql.com/doc/refman/8.0/en/create-view.html

[ikrivosheev]

@billy1624 @espindola I will make PR after some days. I needed to read specification.

[defnotjonas]

Are there updates on this issue? The PR seems stale since 2022.
If there are no reasons against it, I would like to try my hand at this.

[ikrivosheev]

@defnotjonas hello! There is a PR: #293. It needs to add docs and tests)

[defnotjonas]

@ikrivosheev Do you want any help with this? I would happily help writing test and docs.

[ikrivosheev]

@defnotjonas If you can help with the PR it will be so great!

[defnotjonas]

Nice! I will start working on it.

[tyt2y3]

@ikrivosheev thank you.