query-builder

# query-builder

```
                                         _           _ _     _           
                                        | |         (_) |   | |          
   __ _ _   _  ___ _ __ _   _   ______  | |__  _   _ _| | __| | ___ _ __
  / _` | | | |/ _ \ '__| | | | |______| | '_ \| | | | | |/ _` |/ _ \ '__|
 | (_| | |_| |  __/ |  | |_| |          | |_) | |_| | | | (_| |  __/ |   
  \__, |\__,_|\___|_|   \__, |          |_.__/ \__,_|_|_|\__,_|\___|_|   
     | |                 __/ |                                           
     |_|                |___/                                            
```

[![Build Status](https://travis-ci.org/izniburak/query-builder.svg?branch=master)](https://travis-ci.org/izniburak/query-builder)

sql query builder library for crystal-lang


## Installation


Add this to your application's `shard.yml`:

```yaml
dependencies:
  query-builder:
    github: izniburak/query-builder
```


## Usage


```crystal
require "query-builder"
builder = Query::Builder.new

p builder.table("test").where("id", 17).or_where("language", "crystal").get

# Output:
# "SELECT * FROM test WHERE id = '17' OR language = 'crystal' LIMIT 1"


p builder.table('test').select('id, title, status').order_by('id', 'desc').limit(10).get_all
# Output:
# "SELECT id, title, status FROM test ORDER BY id DESC LIMIT 10"
```


## Docs

Documentation Page: [query-builder Docs](https://github.com/izniburak/query-builder/blob/master/DOCS.md)


## Contributing

1. Fork it ( https://github.com/izniburak/query-builder/fork )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request


## Contributors

- [izniburak](https://github.com/izniburak) İzni Burak Demirtaş - creator, maintainer