# Defrag

Defrag is a lightweight Elixir library that provides a convenient macro for writing Ecto fragments using familiar string interpolation syntax. It makes your database queries more readable and maintainable by allowing you to use string interpolation instead of multiple question marks in your Ecto fragments.

## Features

- Write Ecto fragments using familiar string interpolation syntax
- Automatic conversion of interpolated values into proper Ecto fragment parameters
- Safe against SQL injection through Ecto's parameterization
- Supports multiple interpolations in a single fragment

## Installation

If [available in Hex](https://hex.pm/docs/publish), the package can be installed
by adding `defrag` to your list of dependencies in `mix.exs`:

```elixir
def deps do
  [
    {:defrag, "~> 0.1.0"}
  ]
end
```

## Usage

```elixir
# Import the macro
import Defrag

# Instead of writing:
fragment("date_part('year', ?)", some_date)

# You can write:
defrag("date_part('year', #{some_date})")

# Multiple interpolations are supported:
defrag("BETWEEN #{start_date} AND #{end_date}")
# Becomes: fragment("BETWEEN ? AND ?", start_date, end_date)
```

### In Ecto Queries

```elixir
import Ecto.Query
import Defrag

def users_born_in_year(query, year) do
  from u in query,
  where: defrag("date_part('year', #{u.birth_date}) = #{^year}")
end
```

## Documentation

Detailed documentation can be found at [HexDocs](https://hexdocs.pm/defrag).

## License

This project is licensed under the Apache License 2.0 - see the [LICENSE](LICENSE) file for details.