# SQL Verbs in the Schema
**Author**: @worstell
<!-- Status of the document - draft, in-review, etc. - is conveyed via HackMD labels -->

Where `GetUser` is the verb generated from SQL and `Caller` is a verb that injects this query.

Option 1:

module Foo {
    database postgres mydb  
        +migration ...
    
    query GetUser(GetUserQuery) GetUserResult
        +sql query 'SELECT ...'
    
    verb Caller(Request) Response
        +queries foo.GetUser ??? foo.mydb
        +database calls foo.mydb ??? foo.GetUser
}

Option 2:

module Foo {
    database postgres mydb  
        +migration ...

    verb Caller(Request) Response
        +calls foo.GetUser
    
    verb GetUser(GetUserQuery) GetUserResult
        +sql query <shasum>
        +database calls foo.mydb
}

Option 3:

module Foo {
    database postgres mydb  
        +migration ...
        +queries GetUser(GetUserQuery) GetUserResult
    
    verb Caller(Request) Response
        +database calls foo.mydb.GetUser
}