public const string AUTO_KEY = "__dbml_auto_column"

public const string AUTO_PRIMARY_KEY = "__dbml_auto_column_key"

public const string AUTO_PARENT_KEY = "__dbml_auto_column_pk"

public const string AUTO_CHILD_KEY = "__dbml_auto_column_ck"

public const string AUTO_DEPEND_KEY = "__dbml_auto_column_depend"

public const string METHOD_ARRAY = "array"

public const string METHOD_ASSOC = "assoc"

public const string METHOD_LISTS = "lists"

public const string METHOD_PAIRS = "pairs"

public const string METHOD_TUPLE = "tuple"

public const string METHOD_VALUE = "value"

public const array METHODS = [
    "array" => [
        "keyable" => false,
        "entity"  => true,
    ],
    "assoc" => [
        "keyable" => true,
        "entity"  => true,
    ],
    "lists" => [
        "keyable" => false,
        "entity"  => false,
    ],
    "pairs" => [
        "keyable" => true,
        "entity"  => false,
    ],
    "tuple" => [
        "keyable" => null,
        "entity"  => true,
    ],
    "value" => [
        "keyable" => null,
        "entity"  => false,
    ],
]

public const array JOIN_MAPPER = [
    "AUTO"  => "~",
    "INNER" => "+",
    "LEFT"  => "<",
    "RIGHT" => ">",
    "CROSS" => "*",
]

protected function getDatabase(): ryunosuke\dbml\Database

public static function getDefaultOptions(): array

public function __construct(
    string|array|Doctrine\DBAL\Connection|Doctrine\DBAL\Connection[] $dbconfig,
    array $options = []
)

# mysql のよくありそうな例
$db = new Database([
    'driver'        => 'pdo_mysql',
    'host'          => '127.0.0.1',
    'port'          => 3306,
    'user'          => 'username',
    'password'      => 'password',
    'dbname'        => 'test_dbml',
    'charset'       => 'utf8',
    'driverOptions' => [
        \PDO::ATTR_EMULATE_PREPARES  => false,
        \PDO::ATTR_STRINGIFY_FETCHES => false,
    ],
]);

# 単純な配列を与えた場合（単一コネクション）
$db = new Database([
    'driver' => 'pdo_mysql',
    'host'   => '127.0.0.1',
    'port'   => 3306,
    'dbname' => 'example',
]);
// mysql://127.0.0.1:3306/example の単一コネクションが生成される

# 設定配列のいずれかの要素が配列の場合（マスター/スレーブ構成）
$db = new Database([
    'driver' => 'pdo_mysql',
    'host'   => ['127.0.0.1', '127.0.0.2'],
    'port'   => [3306, 3307],
    'dbname' => 'example',
]);
// 下記の2コネクションが生成される（つまり、配列で複数指定したものは個別指定が活き、していないものは共通として扱われる）
// - master: mysql://127.0.0.1:3306/example
// - slave:  mysql://127.0.0.2:3307/example

# コネクションを与える場合
$db = new Database($connection);
// 単一コネクションが使用される

$db = new Database([$connection1, $connection2]);
// $connection1 がマスター、$connection2 がスレーブとして使用される

# defaultOrder は本来 SelectBuilder のオプションだが、 Database のオプションとしても与えることができる
$db = new Database($dbconfig, [
    'defaultOrder' => true,
]);
$db->selectArray('tablename'); // 上記で false を設定してるので自動で `ORDER BY 主キー` は付かない

public function __isset(string $name): bool

public function __unset(string $name)

public function __get(string $name): ?ryunosuke\dbml\Gateway\TableGateway

# t_article の全レコードを取得する
$db->t_article->array();

public function __set(
    string $name,
    mixed $value
)

public function debug(
    callable|string $message,
    callable|array $context = [],
    callable|bool $if = true,
    $level = null
)

public function describe(?string $objectname = null): Doctrine\DBAL\Schema\AbstractAsset

# \Doctrine\DBAL\Schema\Schema を返す
$schema = $db->describe(); // 引数省略時は Schema オブジェクト

# \Doctrine\DBAL\Schema\Table を返す
$table = $db->describe('tablename'); // テーブル名を与えると Table オブジェクト
$view = $db->describe('viewname'); // ビュー名を与えても Table オブジェクト

# \Doctrine\DBAL\Schema\ForeignKeyConstraint を返す
$fkey = $db->describe('fkeyname'); // 外部キー名を与えると ForeignKeyConstraint オブジェクト

# \Doctrine\DBAL\Schema\Column を返す
$column = $db->describe('tablename.columnname'); // テーブル名.カラム名を与えると Column オブジェクト

# \Doctrine\DBAL\Schema\Index を返す
$index = $db->describe('tablename.indexname'); // テーブル名.インデックス名を与えると Index オブジェクト

public function echoTableClass(string $annotation_namespace = ""): array

public function echoAnnotation(
    ?string $namespace = null,
    ?string $filename = null
): string

public function echoPhpStormMeta(
    ?string $namespace = null,
    ?string $filename = null
): string

public function setLogger(Psr\Log\LoggerInterface|Psr\Log\LoggerInterface[]|null $logger): ryunosuke\dbml\Database

public function setAutoCastType(array $castTypes): ryunosuke\dbml\Database

$db->setAutoCastType([
    // DATETIME 型は「取得時は変換」「更新時はそのまま」となるように設定
    Type::DATETIME => [
        'select' => true,
        'affect' => false,
    ],
    // SARRAY 型は「取得時も更新時も変換」となるように設定（単一 bool を与えると select,affect の両方を意味する）
    Type::SIMPLE_ARRAY => true,
    // STRING 型はクロージャで変換する
    Type::String => [
        'select' => function ($colval) {
            // $colval に SELECT 時の値が渡ってくる
        },
        'affect' => function ($colval) {
            // $colval に AFFECT 時の値が渡ってくる
        },
    ],
]);

public function setConnection(Doctrine\DBAL\Connection|bool $connection): ryunosuke\dbml\Database

// 接続をマスターに切り替える
$db->setConnection(true);
// 接続をスレーブに切り替える
$db->setConnection(false);
// 全く別個のコネクションに切り替える
$db->setConnection($connection);

public function getConnection(): Doctrine\DBAL\Connection

public function getMasterConnection(): Doctrine\DBAL\Connection

public function getSlaveConnection(): Doctrine\DBAL\Connection

public function getConnections(): array|Doctrine\DBAL\Connection[]

public function getCompatibleConnection(?Doctrine\DBAL\Connection $connection = null): ryunosuke\dbml\Metadata\CompatibleConnection

public function getPlatform(): Doctrine\DBAL\Platforms\AbstractPlatform

public function getCompatiblePlatform(): ryunosuke\dbml\Metadata\CompatiblePlatform

public function getSchema(): ryunosuke\dbml\Metadata\Schema

public function getEntityClass(string $tablename): string

public function getGatewayClass(string $tablename): string

public function convertEntityName(string $tablename): string

public function convertSelectTableName(string $targetname): string

public function convertAffectTableName(string $targetname): string

public function declareVirtualTable(
    string $vtableName,
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Database

# 仮想テーブルを追加する
$db->declareVirtualTable('v_article_comment', [
    't_article@active' => [
        '*',
        '*t_comment@active' => [
            '*',
        ],
    ],
]);

# 追加した仮想テーブルをあたかもテーブルのように使用できる
$db->selectArray('v_article_comment'); // 上で追加した配列を与えるのと同じ

public function declareCommonTable(array $expressions): ryunosuke\dbml\Database

$db->declareCommonTable([
    'c_table1'    => 'SELECT 1, 2',
    'c_table2(n)' => 'SELECT 1 UNION SELECT n + 1 FROM c_table2 WHERE n < 5',
]);

# 追加した CTE は自動で WITH 句に追加される
$db->selectArray('c_table2');
// WITH RECURSIVE c_table2(n) AS(SELECT 1 UNION SELECT n + 1 FROM c_table2 WHERE n < 5)SELECT c_table2.* FROM c_table2

public function getVirtualTable(string $vtableName): ?array

public function overrideColumns(array $definition): ryunosuke\dbml\Database

# 仮想カラムを追加する
$db->overrideColumns([
    'table_name' => [
        // 単純なエイリアス。ほぼ意味はない
        'hoge'      => 'fuga',
        // 姓・名を結合してフルネームとする（php 版）
        'fullname1' => function($row) { return $v['sei'] . $v['mei']; },
        // 姓・名の SQL 版
        'fullname2' => 'CONCAT(sei, mei)',
        // 姓・名の SQL 版（修飾子）
        'fullname3' => 'CONCAT(%1$s.sei, %1$s.mei)',
        // 上記の例は実は簡易指定で本来は下記の配列を渡す（非配列を渡すと下記でいう select が渡されたとみなす）
        'misc'      => [
            'select'   => null,  // select 時の仮想カラムの定義（文字列や Expression やクエリビルダなど全て使用できる）
            'affect'   => null,  // affect 時の仮想カラムの定義（実列名をキーとする連想配列を返すクロージャを指定する）
            'type'     => null,  // 仮想カラムの型
            'lazy'     => false, // 遅延評価するか（後述）
            'implicit' => false, // !column などの一括取得に含めるか
        ],
        // null を渡すと仮想カラムの削除になる
        'deletedVcolumn' => null,
    ],
]);

# 追加した仮想カラムをあたかもテーブルカラムのように使用できる
$db->selectArray('table_name' => [
    'hoge',
    'fullname1', // php 的に文字列結合（$v['sei'] . $v['mei']）する
    'fullname2', // SQL 的に文字列結合（CONCAT(sei, mei)）する
    'fullname3', // 修飾子付きで SQL 的に文字列結合（CONCAT(AAA.sei, AAA.mei)）する
    // さらにエイリアスも使用できる
    'fullalias' => 'fullname1',
]);

# 仮想カラムの遅延評価
$db->overrideColumns([
    'tableA' => [
        // このようにしないと $db->subselectArray('tableB') が即時評価され、 tableB の評価が始まってしまう（そのとき tableB に parent という仮想カラムはまだ生えていない）
        // つまり children の結果セットに parent が含まれることが無くなってしまう
        'children' => [
            'lazy'   => true,
            'select' => function () use ($db) {
                return $db->subselectArray('tableB');
            },
        ],
    ],
    'tableB' => [
        // 同上（lazy 指定ではなく Database 引数版）
        'parent' => function (Database $db) {
            return $db->subselectTuple('tableA');
        },
    ],
]);

# 仮想カラムの更新処理
$db->overrideColumns([
    'table_name' => [
        'fullname' => [
            // 仮想カラム更新時の処理（$value はその仮想カラムとして飛んできた値, $row は行全体）
            'affect' => function ($value, $row) {
                // fullname が飛んできたらスペース区切りで姓・名に分割して登録する
                $parts = explode(' ', $value, 2);
                return [
                    'sei' => $parts[0],
                    'mei' => $parts[1],
                ];
            },
        ],
    ],
]);

# 仮想ではなく実カラムを指定
$db->overrideColumns([
    'table_name' => [
        'checkd_option'      => [
            // checkd_option という実際に存在するカラムの型を simple_array に上書きできる
            'type'     => Type::getType('simple_array'),
        ],
    ],
]);

public function addRelation(array $relations): array

# 下記のような配列を与える
$db->addRelation([
    'ローカルテーブル名' => [
        '外部テーブル名' => [
            '外部キー名' => [
                'ローカルカラム名1' => '外部カラム名1',
                'ローカルカラム名2' => '外部カラム名2',
                'options' => [
                    'onDelete'  => 'CASCADE',                   // CASCADE 動作はアプリでエミュレーションされる
                    'condition' => ['colname' => 'cond value'], // join や subselect 時に自動付与される条件となる
                ],
            ],
            // 別キー名に対して上記の構造の繰り返しができる
        ],
        // 別外部テーブル名に対して上記の構造の繰り返しができる
    ],
    // 別ローカルテーブル名に対して上記の構造の繰り返しができる
]);

public function addForeignKey(
    string $localTable,
    string $foreignTable,
    array|string $fkdata,
    ?string $fkname = null
): Doctrine\DBAL\Schema\ForeignKeyConstraint

public function ignoreForeignKey(
    string $localTable,
    string $foreignTable,
    array|string $columnsMap
): Doctrine\DBAL\Schema\ForeignKeyConstraint

public function switchForeignKey(
    bool $enable,
    Doctrine\DBAL\Schema\ForeignKeyConstraint|string $fkey
): int

public function begin(): int

public function commit(): int

public function rollback(): int

public function transact(
    callable $main,
    ?callable $catch = null,
    array $options = [],
    bool $throwable = true
): mixed

// このクロージャ内の処理はトランザクション内で処理される
$return = $db->transact(function ($db) {
    return $db->insertOrThrow('t_table', ['data array']);
});

public function transaction(
    ?callable $main = null,
    ?callable $catch = null,
    array $options = []
): ryunosuke\dbml\Transaction\Transaction

public function preview(
    callable $main,
    ?array $options = null
): array

// $logs に実際に投げたクエリが格納される。
$logs = $db->preview(function ($db) {
    $pk = $db->insertOrThrow('t_table', ['data array']);
    $db->update('t_table', ['data array'], $pk);
});

public function raw(
    string $expr,
    mixed $params = []
): ryunosuke\dbml\Query\Expression\Expression

public function operator(...$predicates): ryunosuke\dbml\Query\Expression\Expression

$db->select([
    't_article' => [
        'contain_hoge' => $db->operator(['article_title:%LIKE%' => 'hoge']),
    ],
]);
// SELECT (article_title LIKE ?) AS contain_hoge FROM t_article: ['%hoge%']

$db->select([
    't_article' => [
        'contain_misc' => $db->operator([
            'colA' => 1,
            'colB' => 2,
        ], [
            'colC' => 3,
            'colD' => 4,
            [
                'colE1' => 5,
                'colE2' => 6,
            ]
        ]),
    ],
]);
// SELECT (((colA = ?) AND (colB = ?)) OR ((colC = ?) AND (colD = ?) AND ((colE1 = ?) OR (colE2 = ?)))) AS contain_misc FROM t_article: [1, 2, 3, 4, 5, 6]

public function descriptor(
    string $tableDescriptor,
    array $params = []
): ryunosuke\dbml\Query\TableDescriptor

public function binder(): \ArrayObject|callable

$binder = $db->binder();
// このようにすると値を保持しつつプレースホルダー文字列を返す
$sql = "SELECT * FROM t_table WHERE id IN ({$binder([1, 2, 3])}) AND status = {$binder(1)}";
// $binder はそのままパラメータとして使える
$db->fetchAll($sql, $binder);
// prepare: SELECT * FROM t_table WHERE id IN (?, ?, ?) AND status = ?
// execute: SELECT * FROM t_table WHERE id IN (1, 2, 3) AND status = 1

public function quote(
    mixed $value,
    ?int $type = null
): mixed

public function quoteIdentifier(string $identifier): string

public function queryInto(
    ryunosuke\dbml\Query\Queryable|string $sql,
    iterable $params = []
): string

# 素の文字列
$db->queryInto('SELECT ?', ['xxx']);
// SELECT 'xxx'

# Expression を与えると保持しているパラメータが使用される
$db->queryInto(Expression::new('UPPER(?)', ['yyy']));
// UPPER('yyy')

# Expression というか Queryable 全般がそうなる
$db->queryInto($db->select('tablename', ['id' => 1]));
// (SELECT tablename.* FROM tablename WHERE id = '1')

public function warmup(array|string $table_names = []): array

public function fetch(
    string $method,
    $sql,
    iterable $params = []
)

public function fetchArray(
    $sql,
    iterable $params = []
)

$db->fetchArray('SELECT id, name FROM tablename');
// results:
[
    [
        'id'   => 1,
        'name' => 'name1',
    ],
    [
        'id'   => 2,
        'name' => 'name2',
    ],
];

public function fetchAssoc(
    $sql,
    iterable $params = []
)

$db->fetchAssoc('SELECT id, name FROM tablename');
// results:
[
    1 => [
        'id'   => 1,
        'name' => 'name1',
    ],
    2 => [
        'id'   => 2,
        'name' => 'name2',
    ],
];

public function fetchLists(
    $sql,
    iterable $params = []
)

$db->fetchLists('SELECT name FROM tablename');
// results:
[
    'name1',
    'name2',
];

public function fetchPairs(
    $sql,
    iterable $params = []
)

$db->fetchPairs('SELECT id, name FROM tablename');
// results:
[
    1 => 'name1',
    2 => 'name2',
];

public function fetchTuple(
    $sql,
    iterable $params = []
)

$db->fetchTuple('SELECT id, name FROM tablename LIMIT 1');
// results:
[
    'id'   => 1,
    'name' => 'name1',
];

public function fetchValue(
    $sql,
    iterable $params = []
)

$db->fetchValue('SELECT name FROM tablename LIMIT 1');
// results:
'name1';

public function fetchArrayOrThrow(
    $sql,
    iterable $params = []
)

public function fetchAssocOrThrow(
    $sql,
    iterable $params = []
)

public function fetchListsOrThrow(
    $sql,
    iterable $params = []
)

public function fetchPairsOrThrow(
    $sql,
    iterable $params = []
)

public function fetchTupleOrThrow(
    $sql,
    iterable $params = []
)

public function fetchValueOrThrow(
    $sql,
    iterable $params = []
)

public function fetchOrThrow(
    string $method,
    $sql,
    iterable $params = []
)

public function select(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

// 単純にクエリビルダオブジェクトを取得する
$qb = $db->select('tablename', ['create_date < ?' => '2000-12-23 12:34:56']);

// array/assoc などのプロキシメソッドで直接結果を取得する
$results = $db->selectArray('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchArray と同じ
$results = $db->selectAssoc('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchAssoc と同じ
$results = $db->selectLists('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchLists と同じ
$results = $db->selectPairs('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchPairs と同じ
$results = $db->selectTuple('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchTuple と同じ
$results = $db->selectValue('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // 結果形式は fetchValue と同じ

public function selectArray(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectArrayOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectArrayInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectArrayForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectArrayForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectAssoc(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectAssocOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectAssocInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectAssocForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectAssocForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectLists(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectListsOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectListsInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectListsForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectListsForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectPairs(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectPairsOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectPairsInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectPairsForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectPairsForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectTuple(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectTupleOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectTupleInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectTupleForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectTupleForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectValue(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectValueOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectValueInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectValueForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function selectValueForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entity(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

// 単純にクエリビルダオブジェクトを取得する
$qb = $db->entity('tablename', ['create_date < ?' => '2000-12-23 12:34:56']);

// array/assoc などのプロキシメソッドで直接結果を取得する
$results = $db->entityArray('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // エンティティインスタンスの配列を返す
$results = $db->entityAssoc('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // エンティティインスタンスの連想配列（キーは最初のカラム）を返す
$results = $db->entityTuple('tablename', ['create_date < ?' => '2000-12-23 12:34:56']); // エンティティインスタンスを返す

public function entityArray(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entityArrayOrThrow(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entityArrayInShare(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entityArrayForUpdate(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entityArrayForAffect(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder

public function entityAssoc(
    array|string $tableDescriptor,
    array|string $where = [],
    array|string $orderBy = [],
    array|int $limit = [],
    array|string $groupBy = [],
    array|string $having = []
): ryunosuke\dbml\Query\SelectBuilder