For example, let's say I want to write code to do ...

# exposed

[ziad]

For example, let's say I want to write code to do the following:
Insert if not exists.

What I did:

val userId = try{
                Users.select{
                    Users.deviceId eq requestDeviceId
                }.single()[Users.id]
            } catch (ex : NoSuchElementException)
            {
                Users.insert {
                    it[deviceId] = requestDeviceId
                } get Users.id
            }