我认为不能包含参数，也不能调用示例方法。您需要创建一个静态方法：

public class Whatever {
    public static String generateLorem() {
        return LoremIpsum.getInstance().getWords(100, 120);
    }
}

然后

CREATE ALIAS LOREM FOR "com.foo.Whatever.generateLorem";

rzwitserloot的回答是正确的。
此外，下面是一个完整的示例应用程序，演示了在该答案中看到的方法。
要运行此代码，请替换调用中的file path参数 ds.setURL 根据您的喜好命名和放置数据库文件。然后运行 main 方法。

package work.basil.example;

import com.thedeanda.lorem.LoremIpsum;
import org.h2.jdbcx.JdbcDataSource;

import javax.sql.DataSource;
import java.sql.*;
import java.time.*;

import java.util.Objects;
import java.util.UUID;

public class FiftyMillion
{
    DataSource dataSource;

    public static String generateLorem ( )
    {
        return LoremIpsum.getInstance().getWords( 100 , 120 );
    }

    public static void main ( String[] args )
    {
        FiftyMillion app = new FiftyMillion();

        app.prepareDatabase();
        app.makeRow();
        app.dumpRows();
//        app.populateDatabase();
//        app.exportDatabaseToCsv();
    }

    // Constructor
    public FiftyMillion ( )
    {
        // DataSource
        org.h2.jdbcx.JdbcDataSource ds = Objects.requireNonNull( new JdbcDataSource() );  // Implementation of `DataSource` bundled with H2.
        ds.setURL( "jdbc:h2:/Volumes/blue_disc/fifty_million;" );
        ds.setUser( "scott" );
        ds.setPassword( "tiger" );
        ds.setDescription( "An example database showing ResultSet access to 50 million records." );
        this.dataSource = ds;
    }

    private void prepareDatabase ( )
    {
        String lorem = LoremIpsum.getInstance().getWords( 100 , 120 );
        String sql =
                """
                CREATE ALIAS IF NOT EXISTS LOREM FOR "work.basil.example.FiftyMillion.generateLorem" ;
                CREATE TABLE IF NOT EXISTS thing_
                (
                    nonsense_ text NOT NULL DEFAULT LOREM() ,
                    row_created_ TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP() ,
                    id_ uuid NOT NULL DEFAULT RANDOM_UUID() ,
                    CONSTRAINT thing_pkey_ PRIMARY KEY ( id_ )
                )
                ;
                """;
        try (
                Connection conn = dataSource.getConnection() ;
                Statement stmt = conn.createStatement() ;
        )
        {
            System.out.println( "INFO - Running `prepareDatabase` method." );
            stmt.executeUpdate( sql );
        }
        catch ( SQLException e )
        {
            e.printStackTrace();
        }
    }

    private void makeRow ( )
    {
        try
                (
                        Connection conn = this.dataSource.getConnection() ;
                        Statement stmt = conn.createStatement() ;
                )
        {
//            String lorem = LoremIpsum.getInstance().getWords( 100 , 120 );
            String sql =
                    """
                    INSERT INTO thing_ ()
                    VALUES ()
                    ;
                    """;
            stmt.executeUpdate( sql );
        }
        catch ( SQLException e )
        {
            e.printStackTrace();
        }
    }

    private void dumpRows ( )
    {
        try
                (
                        Connection conn = this.dataSource.getConnection() ;
                        Statement stmt = conn.createStatement() ;
                )
        {
            String sql =
                    """
                    TABLE thing_
                    ;
                    """;
            stmt.executeQuery( sql );
            ResultSet rs = stmt.executeQuery( sql );
            while ( rs.next() )
            {
                String nonsense = rs.getString( "nonsense_" );
                Instant whenCreated = rs.getObject( "row_created_" , OffsetDateTime.class ).toInstant();
                UUID id = rs.getObject( "id_" , UUID.class );
                System.out.println( "whenCreated = " + whenCreated + " | " + "id : " + id + " | " + "nonsense = " + nonsense );
            }
        }
        catch ( SQLException e )
        {
            e.printStackTrace();
        }
    }

    private void populateDatabase ( )
    {

    }

    private void exportDatabaseToCsv ( )
    {
    }

}