queries.js

const SQL = require('sql-template-strings');

module.exports = {
  slice: (start, end) => SQL`
    SELECT
      eventid,
      CAST(latitude AS REAL) AS latitude,
      CAST(longitude AS REAL) AS longitude,
      CAST(nkill AS INT) AS nkill,
      CAST(iyear AS INT) AS year
    FROM
      attacks
    WHERE
      iyear >= ${+start} AND iyear <= ${+end}
  `,
  infoById: id => SQL`
    SELECT * FROM attacks WHERE eventid = ${id}
  `
};