odata-filter-postgresql v1.0.2

OData Filter - PostgreSql Transformer

Postgre transformer for odata-filter package

Installation

npm install odata-filter-postgresql

Usage

Transform a filter string to a PostgreSql query

import { ParseSync } from "odata-filter";
import PostgreSqlTransformer from "odata-filter-postgresql";

const filter = `(user.username == "Ana") or (username == "Mari")`;

try {
    const query = ParseSync(filter, {
        transformer: new PostgreSqlTransformer()
    });

    console.log(query); // ("user"."username" = 'Ana') OR ("username" = 'Ana')
} catch (error) {
    console.error(error);
}

Transform a filter string to a PostgreSql query asynchronously

import { ParseSync } from "odata-filter";
import PostgreSqlTransformer from "odata-filter-postgresql";

const filter = `(user.username == "Ana") or (username == "Mari")`;

Parse(filter, {
    transformer: new PostgreSqlTransformer()
}).then(query => {
    console.log(query); // ("user"."username" = 'Ana') OR ("username" = 'Ana')
}).catch(error => {
    console.error(error);
});

Constructor optional options

Supported Inline Functions