免费开源-jOOQ 是用 Java 编写 SQL 的最佳方式

/* * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * https://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * Other licenses: * ----------------------------------------------------------------------------- * Commercial licenses for this work are available. These replace the above * ASL 2.0 and offer limited warranties, support, maintenance, and commercial * database integrations. * * For more information, please visit: https://www.jooq.org/legal/licensing * * * * * * * * * * * * * * * * */ package org.jooq.impl; import static java.util.Arrays.asList; import static org.jooq.Operator.AND; import static org.jooq.Operator.OR; import static org.jooq.Operator.XOR; // ... // ... // ... // ... // ... // ... // ... // ... // ... import static org.jooq.SQLDialect.CUBRID; // ... // ... import static org.jooq.SQLDialect.DEFAULT; import static org.jooq.SQLDialect.DERBY; import static org.jooq.SQLDialect.DUCKDB; // ... import static org.jooq.SQLDialect.FIREBIRD; // ... // ... import static org.jooq.SQLDialect.H2; // ... import static org.jooq.SQLDialect.HSQLDB; import static org.jooq.SQLDialect.IGNITE; // ... // ... import static org.jooq.SQLDialect.MARIADB; // ... // ... // ... // ... // ... import static org.jooq.SQLDialect.MYSQL; // ... // ... // ... // ... // ... // ... // ... // ... import static org.jooq.SQLDialect.POSTGRES; // ... // ... // ... // ... // ... // ... // ... // ... // ... // ... import static org.jooq.SQLDialect.SQLITE; // ... // ... // ... // ... // ... // ... // ... // ... // ... import static org.jooq.SQLDialect.TRINO; // ... import static org.jooq.SQLDialect.YUGABYTEDB; import static org.jooq.conf.ParamType.INLINED; import static org.jooq.impl.Names.N_COUNT; import static org.jooq.impl.Names.N_CUME_DIST; import static org.jooq.impl.Names.N_DENSE_RANK; import static org.jooq.impl.Names.N_IF; import static org.jooq.impl.Names.N_IIF; import static org.jooq.impl.Names.N_PERCENTILE_CONT; import static org.jooq.impl.Names.N_PERCENTILE_DISC; import static org.jooq.impl.Names.N_PERCENT_RANK; import static org.jooq.impl.Names.N_RANK; import static org.jooq.impl.Names.N_SYSTEM_TIME; import static org.jooq.impl.Names.N_VALUE; import static org.jooq.impl.SQLDataType.BOOLEAN; import static org.jooq.impl.SQLDataType.DATE; import static org.jooq.impl.SQLDataType.INTEGER; import static org.jooq.impl.SQLDataType.JSON; import static org.jooq.impl.SQLDataType.JSONB; import static org.jooq.impl.SQLDataType.TIME; import static org.jooq.impl.SQLDataType.TIMESTAMP; import static org.jooq.impl.Tools.EMPTY_FIELD; import static org.jooq.impl.Tools.combine; import static org.jooq.impl.Tools.configuration; import static org.jooq.impl.Tools.getRecordQualifier; import static org.jooq.impl.Tools.isEmpty; import static org.jooq.impl.Tools.map; import static org.jooq.impl.Tools.mostSpecificArray; import static org.jooq.tools.StringUtils.isEmpty; import java.math.BigDecimal; import java.math.BigInteger; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Time; import java.sql.Timestamp; import java.time.Instant; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.LocalTime; import java.time.OffsetDateTime; import java.time.OffsetTime; import java.time.temporal.Temporal; import java.util.Arrays; import java.util.Collection; import java.util.List; import java.util.Map; import java.util.Properties; import java.util.UUID; import java.util.function.Function; import javax.sql.DataSource; import org.jooq.AggregateFunction; import org.jooq.AlterTableStep; import org.jooq.ArrayAggOrderByStep; // ... // ... import org.jooq.Asterisk; import org.jooq.Binding; import org.jooq.Block; import org.jooq.Case; import org.jooq.CaseConditionStep; import org.jooq.CaseValueStep; import org.jooq.Catalog; import org.jooq.CharacterSet; import org.jooq.CheckReturnValue; import org.jooq.CloseableDSLContext; import org.jooq.Collation; import org.jooq.Comment; import org.jooq.CommonTableExpression; import org.jooq.Condition; import org.jooq.Configuration; import org.jooq.ConnectionProvider; import org.jooq.ConstraintEnforcementStep; import org.jooq.ConstraintForeignKeyReferencesStep1; import org.jooq.ConstraintForeignKeyReferencesStep10; import org.jooq.ConstraintForeignKeyReferencesStep11; import org.jooq.ConstraintForeignKeyReferencesStep12; import org.jooq.ConstraintForeignKeyReferencesStep13; import org.jooq.ConstraintForeignKeyReferencesStep14; import org.jooq.ConstraintForeignKeyReferencesStep15; import org.jooq.ConstraintForeignKeyReferencesStep16; import org.jooq.ConstraintForeignKeyReferencesStep17; import org.jooq.ConstraintForeignKeyReferencesStep18; import org.jooq.ConstraintForeignKeyReferencesStep19; import org.jooq.ConstraintForeignKeyReferencesStep2; import org.jooq.ConstraintForeignKeyReferencesStep20; import org.jooq.ConstraintForeignKeyReferencesStep21; import org.jooq.ConstraintForeignKeyReferencesStep22; import org.jooq.ConstraintForeignKeyReferencesStep3; import org.jooq.ConstraintForeignKeyReferencesStep4; import org.jooq.ConstraintForeignKeyReferencesStep5; import org.jooq.ConstraintForeignKeyReferencesStep6; import org.jooq.ConstraintForeignKeyReferencesStep7; import org.jooq.ConstraintForeignKeyReferencesStep8; import org.jooq.ConstraintForeignKeyReferencesStep9; import org.jooq.ConstraintForeignKeyReferencesStepN; import org.jooq.ConstraintTypeStep; // ... import org.jooq.Converter; import org.jooq.CreateTypeStep; import org.jooq.CreateViewAsStep; import org.jooq.DSLContext; import org.jooq.DataType; import org.jooq.DatePart; // ... import org.jooq.Delete; import org.jooq.DeleteUsingStep; import org.jooq.DerivedColumnList; import org.jooq.Domain; import org.jooq.DropTypeStep; // ... import org.jooq.False; import org.jooq.Field; import org.jooq.FieldOrRow; // ... import org.jooq.Geography; import org.jooq.Geometry; import org.jooq.GroupConcatOrderByStep; import org.jooq.GroupConcatSeparatorStep; import org.jooq.GroupField; // ... import org.jooq.Index; import org.jooq.Insert; import org.jooq.InsertSetStep; import org.jooq.InsertValuesStep1; import org.jooq.InsertValuesStep10; import org.jooq.InsertValuesStep11; import org.jooq.InsertValuesStep12; import org.jooq.InsertValuesStep13; import org.jooq.InsertValuesStep14; import org.jooq.InsertValuesStep15; import org.jooq.InsertValuesStep16; import org.jooq.InsertValuesStep17; import org.jooq.InsertValuesStep18; import org.jooq.InsertValuesStep19; import org.jooq.InsertValuesStep2; import org.jooq.InsertValuesStep20; import org.jooq.InsertValuesStep21; import org.jooq.InsertValuesStep22; import org.jooq.InsertValuesStep3; import org.jooq.InsertValuesStep4; import org.jooq.InsertValuesStep5; import org.jooq.InsertValuesStep6; import org.jooq.InsertValuesStep7; import org.jooq.InsertValuesStep8; import org.jooq.InsertValuesStep9; import org.jooq.InsertValuesStepN; import org.jooq.JSON; import org.jooq.JSONArrayAggOrderByStep; import org.jooq.JSONArrayNullStep; import org.jooq.JSONB; import org.jooq.JSONEntry; import org.jooq.JSONEntryValueStep; import org.jooq.JSONExistsOnStep; import org.jooq.JSONFormat; import org.jooq.JSONObjectAggNullStep; import org.jooq.JSONObjectNullStep; import org.jooq.JSONTableColumnsFirstStep; import org.jooq.JSONValueOnStep; import org.jooq.Keyword; // ... // ... // ... import org.jooq.Merge; import org.jooq.MergeKeyStep1; import org.jooq.MergeKeyStep10; import org.jooq.MergeKeyStep11; import org.jooq.MergeKeyStep12; import org.jooq.Me