search

CSNW / sql-bricks

Transparent, Schemaless SQL Generation
http://csnw.github.io/sql-bricks
MIT License
203 stars 25 forks source link

TRUNCATE feature? #110

Closed privateOmega closed 4 years ago

privateOmega commented 5 years ago

Is it possible to implement Truncate feature in sql-bricks?

joelmukuthu commented 5 years ago

@prust in line with this, are there plans to add support for the newer SQL specs (i.e. after SQL 92)?

prust commented 4 years ago

@privateOmega: This is probably irrelevant to you now (a year later), but FWIW, Truncate is part of the SQL 2008 standard, so I don't plan to add support for it in the sql-bricks core, but others are welcome to add it as an extension (just as a few people have added extensions to support various SQL vendor dialects).

@joelmukuthu: I don't have plans to go beyond SQL92, since I haven't personally found much value in sql-bricks beyond the core statements in SQL92, and I'd like to keep the library small and maintainable. To be honest, in the projects I've worked on in recent years I haven't reached for it as often, or found it as valuable, as I had anticipated, which explains why I haven't invested as much effort into it recently.