---
name: "Text::Query::SolveSQL"
section: "3pm"
platform: "linux"
package: "libtext-querysql-perl"
version: "0.07-6"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/Text::Query::SolveSQL"
---

# Text::Query::SolveSQL(3pm)

Apply query expression to an SQL database

## NAME

Text::Query::SolveSQL - Apply query expression to an SQL database

## SYNOPSIS

```
  use Text::Query;
  my $q=new Text::Query('field1: ( hello and world )',
                        -parse => 'Text::Query::ParseAdvanced',
                        -solve => 'Text::Query::SolveSQL',
                        -build => 'Text::Query::BuildSQLFulcrum',
                        -select => 'select * from t1 where __WHERE__');
```

```
  my $db = DBI->connect(undef, undef, undef);
```

```
  my @rows = $q->match($db);
```

## DESCRIPTION

Applies a select order computed by a `"Text::Query"` object whose builder is derived from `"Text::Query::BuildSQL"` to a `"DBI"` object.

## METHODS

- match (DB)

  Applies the current select order to the database provided by the `"DB"` argument and returns a table of rows that match. Each row is a `"hashref"`.

## SEE ALSO

*Text::Query*(3) *Text::Query::Solve*(3)

## AUTHORS

Loic Dachary (loic@senga.org)