alasql.options.autocommit = true;

/** Log or throw error */
errorlog: false,
/** Use valueof in orderfn */
valueof: true,
/** Callback for async queries progress */
progress: false, 
/** Date separator for Now() function */
nowdateseparator: '-', 
// Date-time Separator for Now() function
nowdatetimeseparator: ' ', 
/** DROP database in any case */
dropifnotexists: false,
/** How to handle DATE and DATETIME types */
datetimeformat: 'sql',
/** Table and column names are case sensitive and converted to lower-case */
casesensitive: true,
/** target for log. Values: 'console', 'output', 'id' of html tag */
logtarget: 'output',
/** Print SQL at log */
logprompt: true,
/** Callback for async queries progress */
progress: false,
/**
 * Default modifier
 * values: RECORDSET, VALUE, ROW, COLUMN, MATRIX, TEXTSTRING, INDEX
 * @type {'RECORDSET'|'VALUE'|'ROW'|'COLUMN'|'MATRIX'|'TEXTSTRING'|'INDEX'|undefined}
 */
modifier: undefined,
/** How many rows to lookup to define columns */
columnlookup: 10,
/** Create vertex if not found */
autovertex: true,
/** Use dbo as current database (for partial T-SQL comaptibility) */
usedbo: true,
/** AUTOCOMMIT ON | OFF */
autocommit: true,
/** Use cache */
cache: true,
/** Check for NaN and convert it to undefined */
nan: false,
/** excel config*/
excel: {cellDates: true},
/** Option for SELECT * FROM a,b */
joinstar: 'overwrite',
/* When false, both NOW and GETDATE will return a Date object instead of a string formatted Date */
dateAsString: true