JavaScript Queries for 2024

[nrllh]

[mgifford]

So the linter wants:
    cast(json_value(summary, '$.firstHtml') AS bool)

to be?
    cast(json_value(summary, '$.firstHtml') AS BOOL)

and 
    SUM(cast(json_value(payload, '$.response.bodySize') AS int64)) / 1024 AS kbytes

to be?
    SUM(cast(json_value(payload, '$.response.bodySize') AS INT64)) / 1024 AS kbytes

I don't know what it wants for:

WHERE
app IN ('jQuery', 'jQuery Migrate', 'jQuery UI', 'Modernizr', 'FancyBox', 'Slick', 'Lightbox', 'Moment.js', 'Underscore.js', 'Lodash', 'React', 'GSAP', 'Vue.js', 'styled-components', 'Emotion', 'Backbone.js', 'RequireJS', 'AngularJS', 'AMP', 'Redux', 'Next.js', 'Stimulus', 'Angular', 'Handlebars', 'Zone.js', 'Marionette.js', 'Mustache', 'Prototype', 'toastr', 'JSS',  'React Router', 'Nuxt.js', 'Alpine.js', 'Svelte', 'MooTools', 'Knockout.js', 'Socket.io', 'Gatsby', 'Adobe Client Data Layer')

[tunetheweb]

There are two spaces between these two terms: 'JSS', 'React Router' which the linter doesn't like. It (quite rightly!) thinks one space is enough.

You can tell this btw because it's saying the error is on Line 24, position 371 of that file.

== [/github/workspace/sql/2024/javascript/frameworks_libraries_by_version.sql] FAIL
L:  24 | P: 371 | L008 | Expected only single space before quoted literal. Found
                       | '  '.
L:  24 | P: 371 | L039 | Expected only single space before quoted literal. Found
                       | '  '.
L:  24 | P: 371 | L048 | Expected only single space before quoted literal. Found
                       | '  '.
All Finished!