Add a method .first on src/granite/query/builder.cr

[guillaume-rce]

Do you think it's possible to add a method ".first" to get the first element get by the query?
Maybe something already exists... If so, let me know 🙂

[crimson-knight]

@guillaume-rce you could just use .limit(1).first

https://docs.amberframework.org/granite/docs/querying#limit

[robacarp]

That's actually already partially implemented:

granite/src/granite/query/assemblers/base.cr

Lines 164 to 176 in f4711b6

	def first(n : Int32 = 1) : Executor::List(Model)
	sql = build_sql do |s|
	s << "SELECT #{field_list}"
	s << "FROM #{table_name}"
	s << where
	s << group_by
	s << order
	s << "LIMIT #{n}"
	s << offset
	end
	Executor::List(Model).new sql, numbered_parameters
	end

But it's not tied into the query DSL for some reason:

granite/src/granite/query/builder.cr

Lines 212 to 219 in f4711b6

	# TODO: replace `querying.first` with this
	# def first : Model?
	# first(1).first?
	# end
	# def first(n : Int32) : Executor::List(Model)
	# assembler.first(n)
	# end

Probably I just never got around to it