Is it possible to assign variable values inside SQLite select statements?

MySQL has the := operator, which can be used inside a SELECT statement (i.e SELECT @var := 1), but I couldn't find a similar operator for SQLite.

Is it even possible to assign a value in such way? I found this answer: Declare variable in sqlite and use it but it requires creating a temporary table beforehand.

Thanks!