Release 2.3.0

• fix security audit dep (e4474a5)
• Merge pull request #91 from paustint/bug-90 (cbfc76c)
• Order by operator is case-sensitive #90 (9dfd62d)
• added favicon and other doc icons (39f027d)
• Updated docs version (ca7cde8)

Release 2.2.3

• Merge pull request #89 from paustint/logo (3dfb2f7)
• Logo update (f851175)
• updated changelog (d8df0a5)
• Updated docs version (adf7071)

Release 2.2.2

• Merge pull request #88 from paustint/bug-87 (e0707b7)
• If an empty orderby array is included, the composed query is invalid #87 (1a71e9a)
• updated issue template (e553f37)
• upadted sample-queries.json (77504b8)
• Updated docs version (ab967ee)

Release 2.2.1

• Merge pull request #86 from paustint/bug-85 (6ee5fbc)
• Group by does not allow multiple fields #85 (ba4f18c)
• Updated docs version (5b60328)

Release 2.2.0

• Merge pull request #84 from paustint/bug-83 (fc68d8e)
• DISTANCE with GEOLOCATION throw errors #83 (ff5e49c)
• Updated docs version (1747dcd)

Release 2.1.0

• Merge pull request #82 from paustint/feature-81 (b58d537)
• getFlattenedFields should allow Query or FieldSubquery or Subquery #81 (d8e6ecd)
• Updated docs version (8fdd851)

Release 2.0.0

2.0.0

Summary

Version 2.0 brings some significant bundle size and performance improvements. This library now uses Chevrotain instead of antlr4. With this change, everything related to parsing had to be re-written from scratch. Chevrotain uses pure javascript to handle lexing, parsing, and visiting the generated ast/cst as opposed to using a grammar file and generating a javascript parser based on the grammar.

With this change, the data model was reviewed and analyzed, and there are some significant breaking changes to the data structures. Review the 🔥breaking changes🔥 below for a detailed description of each breaking change.

Bundle Size

soql-parser-js bundles all of the library code and three dependencies chevrotain (which relies on regexp-to-ast) and lodash.get (required by chevrotain) into the javascript bundle. Previously, antlr4 was not bundled and was required to be installed separately.

To compare the bundle size, the following small program was written and then compiled using the default configuration of webpack, and the output bundle was compared.

• Version 1.x: 545kb (this includes all required dependencies)
• Version 2.0: 197kb (this includes all required dependencies)

var soqlParser = require('soql-parser-js');

const query = soqlParser.parseQuery(`SELECT Id FROM Account WHERE Id = 'FOO'`);
console.log('query', query);
const soql = soqlParser.composeQuery(query);
console.log('soql', soql);

Benchmarks

Here is an example benchmark of parsing all the unit tests 1,000 times

OLD PARSER: ~6.2 seconds for ~60K parses
NEW PARSER: ~2.25 seconds for 60K parses

Breaking Changes 🔥

General Changes

• The CLI was removed.
• The parseQuery() function no longer accepts options as a second parameter.
• rawValue will always have a space between parameters GROUPING(Id, BillingCountry)
• Some literalType values may have differing case from prior versions, regardless of the data input.
  • TRUE, FALSE, and all functions except those listed below will always be returned in uppercase, regardless of case of input.
  • Exceptions:
    • toLabel, convertTimezone, convertCurrency will always be in camelCase.
  • Added new available types for DateLiteral and DateNLiteral.
• A new LiteralType value was added for APEX_BIND_VARIABLE.

Compose Query

• getComposedField() is deprecated, you should now use getField(). getComposedField() will remain available for backward compatibility.
• getField()/getComposedField() has the following changes:
  1. fn property is has been deprecated (but still exists), you should now use functionName instead.
  2. The from property has been removed for subqueries. The relationshipName is required to be populated to compose a subquery.
• On the FormatOptions interface fieldMaxLineLen was renamed to fieldMaxLineLength.

export interface FormatOptions {
  numIndent?: number;
- fieldMaxLineLen?: number;
+ fieldMaxLineLength?: number;
  fieldSubqueryParensOnOwnLine?: boolean;
  whereClauseOperatorsIndented?: boolean;
  logging?: boolean;
}

Parse Query

• rawValue will now be included on Field if objectPrefix is defined.
• alias may be included on Field, if defined.
• On FieldFunctionExpression, fn was renamed to functionName. this was done because all other usages of fn were FunctionExp, but it was a string in this case.
• The parameters type on FieldFunctionExpression was modified to allow an array of varying types.
• Removed from property from FieldSubquery.
• having was removed from QueryBase and now lives as a property on GroupByClause.
• On the Condition object, literalType may be an array. This will be an array if value is an array and there are variable types within the value. For example: WHERE Foo IN ('a', null, 'b') would produce literalType: ['STRING', 'NULL', 'STRING'].
• The GroupByClause has the following modifications:
  • field is now optional, and will be populated only if the grouping is on a single field.
  • type has been renamed to fn and will be populated when CUBE and ROLLUP are used.
  • The having clause has been moved as a top-level property to the GroupByClause and will be populated only if a having clause is present.
• The HavingCondition now has a literalType that will be populated with the type of the value property.
• FunctionExp has the following modifications
  • text was renamed to rawValue to be more consistent with other places in the data model.
  • name was renamed to functionName.
  • parameter was renamed to parameters and the type was changed to (string | FunctionExp)[] to support nested functions. This will ALWAYS be an array now even if there is only one parameter.
  • fn was removed, as nested functionParameters are always stored as an entry in the parameters array.

export interface Field {
  type: 'Field';
  field: string;
  objectPrefix?: string;
+ rawValue?: string;
+ alias?: string;
}

export interface FieldFunctionExpression {
  type: 'FieldFunctionExpression';
- fn: string;
+ functionName: string;
- parameters?: string[] | FieldFunctionExpression[];
+ parameters?: (string | FieldFunctionExpression)[];
  alias?: string;
  isAggregateFn?: boolean;
  rawValue?: string;
}

export interface FieldRelationship {
  type: 'FieldRelationship';
  field: string;
  relationships: string[];
  objectPrefix?: string;
  rawValue?: string;
+ alias?: string;
}

export interface FieldSubquery {
  type: 'FieldSubquery';
  subquery: Subquery;
- from?: string;
}

export interface QueryBase {
  fields: FieldType[];
  sObjectAlias?: string;
  where?: WhereClause;
  limit?: number;
  offset?: number;
  groupBy?: GroupByClause;
- having?: HavingClause;
  orderBy?: OrderByClause | OrderByClause[];
  withDataCategory?: WithDataCategoryClause;
  withSecurityEnforced?: boolean;
  for?: ForClause;
  update?: UpdateClause;
}

export interface Condition {
  openParen?: number;
  closeParen?: number;
  logicalPrefix?: LogicalPrefix;
  field?: string;
  fn?: FunctionExp;
  operator: Operator;
  value?: string | string[];
  valueQuery?: Query;
- literalType?: LiteralType;
+ literalType?: LiteralType | LiteralType[];
  dateLiteralVariable?: number;parsed
}

export interface GroupByClause {
- field: string | string[];
+ field?: string | string[];
- type?: GroupByType;
+ fn?: FunctionExp;
+ having?: HavingClause;
}

export interface HavingCondition {
  openParen?: number;
  closeParen?: number;
  field?: string;
  fn?: FunctionExp;
  operator: string;
  value: string | number;
+ literalType?: String;
}

export interface FunctionExp {
- text?: string;
+ rawValue?: string;
- name?: string;
+ functionName?: string;
  alias?: string;
- parameter?: string | string[];
+ parameters?: (string | FunctionExp)[];
  isAggregateFn?: boolean;
- fn?: FunctionExp;
}

resolves #72
resolves #34

Release 2.0.0-rc.6

• Updated having clause (d6761c7)
• Updated docs version (abe5435)

Release 2.0.0-rc.5

• Enforce balanced parens (c098148)
• removed getAlt() helper (c44c27b)
• Updated docs (e0a5b92)
• Updated docs version (4d8520f)

Release 2.0.0-rc.4

• Added additional queries to docs (f64f986)
• Additional maintenance (a3d254b)
• OFFSET is not properly parsed #74 (3431b11)
• fix build (4541c53)
• Updates and bugfixes (a48f73a)
• updates changelog to include additional on FunctionExp (20635c5)
• \Updated docs version\ (f01da01)