Make your query fast and build it easly. 

jafetguerra

fastquery-builder

Error

Ignore

Warn

License

Maintenance

Miscellaneous

Quality

Supply chain risk

Vulnerability

Admins only

Organization members

Dashboard

<upgradeLink>Upgrade</upgradeLink> to access this feature

About

Blog

Socket CLI

Customers

Socket Dependency Search

Docs

Socket for GitHub

Love

Impersonation Mode Active

Update your browser to the latest version for the best experience.

Your web browser is outdated

Use another browser for the best experience.

Your web browser is unsupported

{{count, number}} commits last two months

{{count, number}} critical severity alert

{{count, number}} critical severity alerts

{{count, number}} dependency vulnerability

{{count, number}} dependency vulnerabilities

{{count, number}} development dependencies

{{count, number}} transitive dependencies

{{count, number}} version published last month

{{count, number}} versions published last month

{{count, number}} version published in last two months

{{count, number}} versions published in last two months

{{count, number}} version published last week

{{count, number}} versions published last week

{{count, number}} version published last year

{{count, number}} versions published last year

Socket undergoes annual SOC2 Type II audits. Socket customers can request a copy of the full SOC2 Type II report.

Allows organization owners and admins to access detailed records of actions taken by members of their organization, complete with timestamps.

Prevent compromised packages from infiltrating your supply chain by monitoring for changes in real-time.

Join our Discord community to get help from Socket engineers and other Socket users.

Compare millions of open source packages on socket.dev

Detect malicious code and risky behavior (e.g. network) in your dependencies using "deep package inspection"

All data is encrypted in transit and at rest using industry standard encryption algorithms.

Get a dedicated Socket account manager and access to Socket’s Customer Success team.

Get dedicated support from Socket engineers via email and Slack.

"Shift left" with the Socket Chrome extension and give intervene early, before developers choose risky or low quality dependencies.

Catch developers using risky dependencies and give them a "speed bump" to encourage good behavior

Install the Socket GitHub app to receive real-time dependency scanning and reports with every pull request.

Integrate Socket into your GitHub SCM to prevent risky dependencies from being installed.

Socket scans for vulnerabilities in your dependencies, including CVEs, security advisories, and more.

Socket supports dependencies in many languages, with most popular ecosystems coming in 2024. We've got you covered no matter what languages you use.

Enforce license policies across your organization

Receive a Microsoft Teams message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Get help migrating from Socket's free plan to Socket's paid plans.

Run Socket on-premises or in your own cloud environment.

Query for any dependency (at any version) across your entire organization

Integrate Socket into your CI/CD pipeline to prevent risky dependencies from being deployed to production.

Analyze an entire project to find supply chain risks

Tag projects to organize and filter your projects

Restrict access based on the roles of individual users within an organization.

Receive a Slack message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket is SOC2 Type II compliant and undergoes annual audits.

The Socket CLI allows teams to prevent risky dependencies from being installed, and to get dependency insights from the command line.

Socket supports SAML SSO for single sign-on and identity management.

Integrate Socket into your VS Code IDE to prevent risky dependencies from being installed.

Get a POST request anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket will analyzed your SBOMs up to a maximum number of dependencies.

API that allows you to analyze a project, lookup package scores and alerts, and more.

Create API tokens to authenticate with the Socket API and CLI.

The number of developers in your team. A developer is someone who made a commit to your organization's repositories scanned by Socket in the past month.

Use Socket to protect your private repositories.

Socket is always free for open source projects.

Socket retains all reporting data for 3 months, 1 year, or a custom term of your choice.

Access the threat feed that powers Socket.

Unlimited scale, self-hosting, and priority support for large teams.

For open-source projects, individuals, and small teams.

For growing teams with enhanced scale, security, and support.

There is a package with a similar name that is downloaded much more often.

There are packages with similar names that are downloaded much more often.

This may not be the package you want!

Instance

Alert Locations

Package

The {{ecosystem}} package {{- packageName}} receives a total of <strong>{{numWeeklyDownloadCount, number}}</strong> weekly downloads. As such, {{- packageName}} popularity was classified as <strong>{{popularity}}</strong>.

Is {{- packageName}} popular?

Is {{- packageName}} safe to use?

Is {{- packageName}} well maintained?

What is {{- packageName}}?

{{packageDescription}}Version: {{versionString}} was published by {{publisherName}}. Start using Socket to analyze {{- packageName}} and its {{dependencyCount, number}} dependencies to secure your app from supply chain attacks.

Sorry, it seems this package was removed from the registry

Package was removed

This package version has been unpublished, mostly likely due to security reasons

Package version was removed

Provide a detailed description of the malware...

Socket fights vulnerabilities and provides visibility, defense-in-depth, and proactive supply chain protection for JavaScript, Python, and Go dependencies.

Socket - Secure your dependencies. Ship with confidence.

Compare versions

{{- packageName}} - npm Package Compare versions

const clickhouseFormat = (clickhouseObj) => {

  const arrayOfObjects = clickhouseObj.data.map((element) => {

    const objToAdd = element.reduce((acc, data, index) => {

      acc[clickhouseObj.meta[index].name] = data;

export function transformFilter(col, value) {

  if (Array.isArray(value)) return `${col} IN (${value})`;

 * @params {[{ col, value: Array | String |Number}]} list

  return list.reduce((acc, filter, index) => {

    if (index === 0) return `WHERE ${filter}`;

    if (index === 0) return `HAVING ${filter}`;

  return list.reduce((acc, filter) => `${acc} AND ${filter}`, "");

function conditionalInArrayExists(col, value, not) {

  if (Array.isArray(value) && value.length > 0) {

    const commas = `'${value.join(`', '`)}'`;

    if (not) return `arrayExists(x -> in(x, (${commas})), ${col}) = 0`;

    return `arrayExists(x -> in(x, (${commas})), ${col}) = 1`;

function conditionalWhereHasAny(col, value, not) {

    if (not) return `hasAny(${col}, [${commas}]) = 0`;

    return `hasAny(${col}, [${commas}]) = 1`;

function conditionalWhereHasAll(col, value, not) {

    if (not) return `hasAll(${col}, [${commas}]) = 0`;

    return `hasAll(${col}, [${commas}]) = 1`;

function conditionalWhereArrayAll(col, value, not) {

    if (not) return `arrayAll(${col}, [${commas}]) = 0`;

    return `arrayAll(${col}, [${commas}]) = 1`;

function conditionalWhereEqual(col, value, not) {

    const fvalue = typeof value === "string" ? `'${value}'` : value;

    if (not) return `${col} != ${fvalue}`;

function conditionalWhereOp(col, operator, value) {

    return `${col} ${operator} ${fvalue}`;

function conditionalWhereIN(col, value, not) {

    if (not) return `${col} NOT IN (${commas})`;

function conditionalWhereBetween(col, values, not, isSorted) {

  if (Array.isArray(values) && values.length === 2) {

      ? values.sort((a, b) => parseInt(a, 10) - parseInt(b, 10))

    if (not) return `${col} NOT BETWEEN ${init} AND ${end}`;

    return `${col} BETWEEN ${init} AND ${end}`;

function conditionalWhereLike(col, value) {

  if (value && typeof value === "string") {

    const fvalue = value.replace(/\s/g, "%");

function conditionalWhereCaseInsensitive(col, value) {

  if (value && typeof value === "string")

    return `positionCaseInsensitive(${col}, '${value}') > 0`;

function conditionalWhereIsNot(col, value) {

  const fvalue = typeof value === "string" ? `'${value}'` : value;

  caseInsensitive: conditionalWhereCaseInsensitive,

  inArrayExists: conditionalInArrayExists,

export { default as clickhouseFormat } from './clickhouseFormat.js';

const clickhouseFormat = require('./clickhouseFormat')

const handleQueries = require('./handleQueries')

  "description": "Make your query fast and build it easly",

  "repository": "git@github.com:3fydev/fastquery.git",

  "author": "Jafet <jafet.fagundes@3fy.com.br>",

		@@ -1,2 +0,2 @@
		export function transformFilter(col, value) {
		function transformFilter(col, value) {
		if (Array.isArray(value)) return `${col} IN (${value})`;
		@@ -9,3 +9,3 @@ return `${col} = ${value}`;
		*/
		export function where(list) {
		function where(list) {
		return list.reduce((acc, filter, index) => {
		@@ -17,3 +17,3 @@ if (index === 0) return `WHERE ${filter}`;

		export function having(list) {
		function having(list) {
		return list.reduce((acc, filter, index) => {
		@@ -123,3 +123,3 @@ if (index === 0) return `HAVING ${filter}`;

		export const conditionalWhere = {
		module.exports = {
		equal: conditionalWhereEqual,
		@@ -136,2 +136,5 @@ op: conditionalWhereOp,
		arrayAll: conditionalWhereArrayAll,
		transformFilter,
		where,
		having,
		};

		@@ -1,2 +0,7 @@
		export { default as clickhouseFormat } from './clickhouseFormat.js';
		export * from './handleQueries.js';
		const clickhouseFormat = require('./clickhouseFormat')
		const handleQueries = require('./handleQueries')

		module.exports = {
		clickhouseFormat,
		...handleQueries,
		}

		{
		"name": "fastquery-builder",
		"version": "1.0.5",
		"version": "1.0.6",
		"description": "Make your query fast and build it easly",
		"main": "index.js",
		"repository": "git@github.com:3fydev/fastquery.git",
		"type": "module",
		"keywords": [
		@@ -9,0 +8,0 @@ "fast",

Improved metrics

Worsened metrics

		@@ -12,2 +12,2 @@ const clickhouseFormat = (clickhouseObj) => {

		export default clickhouseFormat;
		module.exports = clickhouseFormat;