Method toString

src/statements/Select.js:32–82

* Convert SELECT to SQL string representation

()

	 * Convert SELECT to SQL string representation
	 */
	toString() {
		let s = 'SELECT ';
		if (this.distinct) {
			s += 'DISTINCT ';
		}
		if (this.columns && this.columns.length > 0) {
			s += this.columns
				.map(col => {
					let cs = col.toString ? col.toString() : String(col);
					if (col.as) {
						cs += ' AS ' + col.as;
					}
					return cs;
				})
				.join(', ');
		} else {
			s += '*';
		}
		if (this.from) {
			s +=
				' FROM ' +
				this.from
					.map(f => {
						let fs = f.toString ? f.toString() : String(f);
						if (f.as) {
							fs += ' AS ' + f.as;
						}
						return fs;
					})
					.join(', ');
		}
		if (this.where) {
			s += ' WHERE ' + (this.where.toString ? this.where.toString() : String(this.where));
		}
		if (this.group) {
			s += ' GROUP BY ' + this.group.map(g => g.toString()).join(', ');
		}
		if (this.having) {
			s += ' HAVING ' + this.having.toString();
		}
		if (this.order) {
			s += ' ORDER BY ' + this.order.map(o => o.toString()).join(', ');
		}
		if (this.limit !== null) {
			s += ' LIMIT ' + this.limit;
		}
		if (this.offset !== null) {
			s += ' OFFSET ' + this.offset;
		}
		return s;
	}
}

/**